Posted to microsoft.public.excel.programming

dreamer[_13_] dreamer[_13_] is offline

external usenet poster

Posts: 1

lenght of a number

Is there something that I should know about function lenght an
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. An
Len(start) always returns 8 as lenght of the number??
What am I doing wrong

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cell lenght MUST be always 30	JABAgdl	Excel Discussion (Misc queries)	5	February 19th 10 08:19 PM
How to convert number in to time lenght, minutes and seconds?	Bojan	Excel Discussion (Misc queries)	3	November 3rd 08 07:35 AM
Max Formula Lenght	Milind Keer[_2_]	Excel Discussion (Misc queries)	3	September 3rd 08 06:40 PM
Lenght of sheets	Dupie1	Excel Worksheet Functions	2	March 18th 08 07:31 PM
Lenght of a decimal part of a number.	Yara	Excel Worksheet Functions	4	October 5th 07 10:27 PM

All times are GMT +1. The time now is 02:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us