Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a data field that I want to instert a leading zero (where necessary)
so that I may sort the data correctly. Is there an easy way to do this? My service codes currently sort as follows: 32-1 32-10 32-11 32-12 32-2 32-20 32-21 32-3 Is there formula that will insert a leading zero into the 32-1, 32-2, 32-3 etc. to make it 32-01, 32-02, 32-03? Thanks for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format a cell to keep leading zeros. | New Users to Excel | |||
insert a JPEG into EXCEL 2002 | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
Adding Leading Zeros to Text | Excel Discussion (Misc queries) | |||
How do I display leading zeros so I can export a fixed in Excel? | Excel Discussion (Misc queries) |