add "0" to the beginning of each value  
Author Message
Archgrad





PostPosted: Tue Jun 21 11:14:01 CDT 2005 Top

worksheet functions >> 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

Excel251  
 
 
Anne





PostPosted: Tue Jun 21 11:14:01 CDT 2005 Top

worksheet functions >> add "0" to the beginning of each value Try this, Jane:
http://www.officearticles.com/excel/show_leading_zeroes_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com





> 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





PostPosted: Tue Jun 21 11:12:56 CDT 2005 Top

worksheet functions >> add "0" to the beginning of each value If it is just presentation, use a custom format of 0000.

--
HTH

Bob Phillips



> 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





PostPosted: Tue Jun 21 11:27:14 CDT 2005 Top

worksheet functions >> add "0" to the beginning of each value
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


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15101
View this thread: http://www.excelforum.com/showthread.php?threadid=380918