Now I can't sort the data, taking into account the zeroes. Does my entire
list of numbers need to be formatted a special way to force the zeroes into
order? It seems that currently the sorting is reliant on actual numbers in
the cells. Thanks.

"T. Valko" wrote:

Use a custom number format.

Select the cells in question
Goto the menu FormatCellsNumber tabCustom
Enter 10 zeros in the little box under TYPE:
0000000000
OK out

--
Biff
Microsoft Excel MVP


"George" wrote in message
...
I have a range of numbers; some are 7 digits long, others, 8, 9 or 10
digits.
How can I tell Excel to put zeroes in front of the numbers that don't have
full ten digits? I want the result to be ten digits long for everything.
Excel 2003. Hopefully this is an easy one for most! Thanks for the help.