Posted to microsoft.public.excel.misc

Cheri

external usenet poster

Posts: 53

I need to drop some leading zeros

I have a spreadsheet with ID numbers. We only use 6 numbers but the IDs send
to me contain 3 zeros in front I don't need (000051585) How can I format the
numbers to drop off those first 3 zeros?

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
Leading Zeros	[email protected]	Excel Discussion (Misc queries)	6	August 3rd 06 06:15 PM
Leading zeros	mary	Excel Discussion (Misc queries)	1	January 18th 06 01:56 PM
Leading Zeros	Karen	Excel Discussion (Misc queries)	3	January 10th 06 09:50 PM
save text field w/ leading zeros in .csv format & not lose zeros?	Ques	Excel Discussion (Misc queries)	1	May 4th 05 06:21 PM
Leading zeros	JC	Excel Discussion (Misc queries)	9	February 1st 05 02:33 PM

All times are GMT +1. The time now is 12:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us