add "0" to the beginning of each value

[Guest]

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

 

[Bob Phillips]

If it is just presentation, use a custom format of 0000.

 

[Anne Troy]

Try this, Jane:
http://www.officearticles.com/excel/show_leading_zeroes_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[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