Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get the zeros to show up in the beginning of a number? | Excel Discussion (Misc queries) | |||
add characters to beginning of text | Excel Worksheet Functions | |||
How do I display an insignificant 0 at the beginning of a number | Excel Discussion (Misc queries) | |||
only include cells beginning with specified character or number | Excel Worksheet Functions | |||
How to link endings balances to beginning balances on different sh | Excel Worksheet Functions |