Robin Blackwell

Posts: n/a

Formatting numbers

Hi all,

I have a huge column of numbers that I wish to sort into increasing value.
They all contain 8 digits (eg 12345678), but a large number have leading
zeros (eg 00001234), which I want to retain. How do I format the column so
that when I run a sort I do not lose the leading zeros please? I am using
Excel 2003.

Thanks

Robin

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
large numbers not losing the end without formatting column	Kevin	Excel Discussion (Misc queries)	4	September 14th 05 09:21 PM
Conditional Formatting on Whole Numbers?	excelgurudummy	Excel Worksheet Functions	6	July 21st 05 03:15 AM
Formatting: when typing the numbers "2004" then a period or simili	sportmarty	Excel Discussion (Misc queries)	1	May 3rd 05 05:03 PM
formatting numbers	jonas	Excel Worksheet Functions	3	February 16th 05 06:12 PM
Why does 26000 display as 260.00 after formatting for numbers	shiv	Excel Discussion (Misc queries)	1	January 31st 05 10:13 AM

All times are GMT +1. The time now is 06:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us