Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to put dashes in a number 13000000000 to 1300-000-0000
how to put dashes in a number 13000000000 to 1300-000-0000
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to put dashes in a number 13000000000 to 1300-000-0000
=LEFT(A1,4)&"-"&MID(A1,5,3)&"-"&RIGHT(A1,4)
the above is if A1 contains your value. "Jimbo" wrote: how to put dashes in a number 13000000000 to 1300-000-0000 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to put dashes in a number 13000000000 to 1300-000-0000
Use a custom format of
0000-000-0000 if you need it as text, use a help column and a formula like =TEXT(A2,"0000-000-0000") copy down/across, then select all formula and copy and paste special as values in place -- Regards, Peo Sjoblom "Jimbo" wrote in message ... how to put dashes in a number 13000000000 to 1300-000-0000 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing dashes from ISBN's while still keeping 1st number (zero) | Excel Worksheet Functions | |||
removing dashes changes test into number | Excel Discussion (Misc queries) | |||
How do I format a social security number to have no dashes? | Excel Discussion (Misc queries) | |||
Phone number format from 000.000.0000 to (000)000-0000 | Excel Discussion (Misc queries) | |||
(social security number) 000-00-0000 to 000000000 | Excel Discussion (Misc queries) |