Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change format ###-###-#### to ##########
I tried custom format but it would not remove my hypens. I need that format
for an export |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change format ###-###-#### to ##########
your data may be text
try =substitute(entry,"-","") if the hyphons do not go away, they may be non breaking hyphons copy one of the hyphons and put into the substitute() function "jmjt" wrote: I tried custom format but it would not remove my hypens. I need that format for an export |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change format ###-###-#### to ##########
BJ you are the BEST, oh my gosh, it worked perfectly. Maybe I won't go home
with a headache today! Thanks Again "bj" wrote: your data may be text try =substitute(entry,"-","") if the hyphons do not go away, they may be non breaking hyphons copy one of the hyphons and put into the substitute() function "jmjt" wrote: I tried custom format but it would not remove my hypens. I need that format for an export |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
excel numbers in general format i cant add cant change format | Excel Worksheet Functions | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel |