| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to keep zeros at the begining of a number
When I merge data together the zeros are removed from the begining of the data.
EX SSSD 001234 0 , when merged by =(cell "A2" & cell "B2" & cell "c2") the zero are removed making it: "SSSD1234" when it needs to be "SSSD0012340" How do I maintain the zeros in the data I want to merge?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
| change negative sign from end of the number to the begining | Excel Discussion (Misc queries) | |||
| option to keep zero at begining of number | Excel Discussion (Misc queries) | |||
| how to add symbol automatically at begining and end | Excel Discussion (Misc queries) | |||
| Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
Threaded Mode
