Add an apostrophe before the leading 0 before doing your EditReplace or
whatever editing you used.

Or if all numbers the same length, Custom Format to 0000000000000


Gord Dibben MS Excel MVP

On Tue, 15 Jan 2008 13:57:01 -0800, Tommy Kramer 9
wrote:

I had a column of numbers with dashes in between like this 08-188-22-33-0044.
I found and edited out the dashes so it looks like 818822330044. The
problem is that it removed the zeros at the beginning of the number and I
can't get them to display.