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
|