View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Fatz[_2_] Fatz[_2_] is offline
external usenet poster
 
Posts: 3
Default lenght of a number

dreamer < postulated on 2/25/2004 8:03 AM:
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/


To count the number of digits to the left of the decimal point . . .
=INT(LOG10(A3))+1