add "0" to the beginning of each value
 

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

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

--
HTH

Bob Phillips

"Jane" wrote in message
...
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

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

www.OfficeArticles.com
www.MyExpertsOnline.com



"Jane" wrote in message
...
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

Because Excel 'ignores' leading zeros in numbers, the best way is to use
Custom Format. Highlight all affected cells, choose FormatCells. 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


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=380918