Formatting numbers

[Robin Blackwell]

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

 

[Guest]

Format > Cells > Number > Custom

Then enter 00000000
in the type field. This will retain the leading zeros and still allow the
sorting.