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 |
#2
|
|||
|
|||
Hello Marta-
As long as 000 appears nowhere other than at the end of each cell's content, you can use Ctrl+H (Find & Replace) and put 000 in the 'Find what:' field, don't put anything in the 'Replace with:' field. If 000 does appeare elsewhere, you can still use this technique, but you have to use the Replace button instead of Replace All. For the format, select the cells and go to Format CellsNumber and select Custom at the bottom of the list. Type 000-00000-00 in the 'Type:' field & click OK. HTH |:) "Marta" wrote: 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 |
Reply |
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) |