Hi
normally I would suggest not to use string operations on numbers. what
are you trying to achieve with this function - there may be better
solutions. But if you want to use Len you may try
Left (CStr(start), Len(CStr(start))-2)

--
Regards
Frank Kabel
Frankfurt, Germany

Is there something that I should know about function lenght and
numbers?

I have used this in a loop:

[vb]

Left (start, Len(start)-2)

[vb]

with "start" being a number that changes from 5.0 to 110.5. And
Len(start) always returns 8 as lenght of the number??
What am I doing wrong?


---
Message posted from http://www.ExcelForum.com/