Posted to microsoft.public.excel.misc

dingy101

Posts: n/a

removing leading zeros in numeric fields

How do I remove leading Zeros in numeric fields that are less than 1.000?

example, 0.123, I would like to have .123.

Thanks

Gary

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
Spliting a number with leading zeros	haitch2	Excel Discussion (Misc queries)	7	September 30th 05 12:09 AM
CSV File - Leading Zeros	Floridagal	Excel Discussion (Misc queries)	2	August 6th 05 12:34 AM
How do I force leading zeros in an Excel cell?	EricKei	Excel Discussion (Misc queries)	2	June 15th 05 08:28 PM
Leading zeros	Paul	Excel Discussion (Misc queries)	4	June 12th 05 04:04 AM
Leading Zeros in Numeric Values	DBavirsha	Excel Worksheet Functions	6	January 4th 05 05:21 PM

All times are GMT +1. The time now is 09:53 PM.

About Us

"It's about Microsoft Excel"