Displaying a zero

[Tommy Kramer 9]

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.

 

[FSt1]

hi
to display leading zeros, you have to formate the number as text or lead it
with an apostophe. You can create a custom format to display a leading zero
on the screen but in the formula bar, it will not have the leading zero. and
if you copy, paste or export.....no leading zero. formating does not change
data, it just changes the way it looks on the screen.

regards
FSt1

 

[David Biddulph]

=SUBSTITUTE(A2,"-","")

 

[Gord Dibben]

Add an apostrophe before the leading 0 before doing your Edit>Replace or
whatever editing you used.

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


Gord Dibben MS Excel MVP