Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number formating
I have a column of numbers, all 6 digit. Some of the numbers are six digit
with a dash in between the third and fourth digit Ex. 123-456 122-451 122771 122458 233-564 ....and so on Is there a way to remove the dashes from these numbers that have dashes and leave the other ones alone? What I want is this column to not have any dashes. is concentate the formula to use?? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
Formating a number | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) |