Posted to microsoft.public.excel.misc

external usenet poster

Posts: 1

How to remove 0's in front of numbers?

I have a column of numbers, as below. How can I remove the 0 in front?

035000
035002
035006
035009

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
remove spaces in front of text	dolphin	Excel Discussion (Misc queries)	2	October 8th 08 05:30 PM
Remove space in front of number in a cell?	Barcelona	Excel Worksheet Functions	5	September 18th 08 02:43 PM
Macro to remove space at front and end of a cell	yhoy	Excel Discussion (Misc queries)	2	February 22nd 08 09:53 PM
add zeros in front of numbers	dlb1228	Excel Discussion (Misc queries)	3	March 29th 07 05:48 PM
How do I keep zeros in front of other numbers (like a zip code)?	RitoruIkko	Excel Discussion (Misc queries)	2	June 30th 06 03:19 PM

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

About Us

"It's about Microsoft Excel"