| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Custom format
I have a column of 13 digit numbers imported from another program. They all
end in 000. I need to first remove the 000 and then format them to look like this 123-45678-90. TIA for your help. Marta |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
| Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
| How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
| Custom Format for ¢ | Excel Discussion (Misc queries) | |||
| Custom Time Format doesn't work for me | Excel Discussion (Misc queries) | |||
Threaded Mode
