add "0" to the beginning of each value

[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

[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

[Anne Troy]

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

www.OfficeArticles.com
www.MyExpertsOnline.com



"Jane" <[email protected]> wrote in message
news:[email protected]...
> 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.

--
HTH

Bob Phillips

"Jane" <[email protected]> wrote in message
news:[email protected]...
> 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