| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
adding zero's to a text cell
Hi,
I have a cell with 5 digits stored as text. I need to add 3 zeros to the cell so my total digits in the cell = 7. How can I add the zeros to the beginning of the cell? ie. current digits = 4204, desired outcome = 0004204. The cell must remain in text format. Thanks, -- Jennifer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text from text box to cell | Excel Worksheet Functions | |||
| dynamic cell reference within a text string | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
| Text is not showing up in cell. Why not? | Excel Discussion (Misc queries) | |||
Threaded Mode
