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