add "0" to the beginning of each value

J

Jane

my data reads:
627
628
629,
etc.

I need to add a "0" to the front of each number. Is there an easy formula
to do this?

thanks! jane
 
S

swatsp0p

Because Excel 'ignores' leading zeros in numbers, the best way is to use
Custom Format. Highlight all affected cells, choose Format>Cells. On
the Number tab, select Custom and set the format to '0000'. Click OK.
All cells will now have a leading zero. Note that a two digit number
(e.g. 12) will have TWO leading zeros (0012).

Another option is to format the cells as text and then enter your
number with the leading zero: (e.g. 0123)

HTH

Bruce
 
Top