Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Format Cells Number Custom
Then enter 00000000 in the type field. This will retain the leading zeros and still allow the sorting. -- Gary's Student "Robin Blackwell" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
large numbers not losing the end without formatting column | Excel Discussion (Misc queries) | |||
Conditional Formatting on Whole Numbers? | Excel Worksheet Functions | |||
Formatting: when typing the numbers "2004" then a period or simili | Excel Discussion (Misc queries) | |||
formatting numbers | Excel Worksheet Functions | |||
Why does 26000 display as 260.00 after formatting for numbers | Excel Discussion (Misc queries) |