| 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 |
| 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 | |||
Threaded Mode
