how to put dashes in a number 13000000000 to 1300-000-0000
 

how to put dashes in a number 13000000000 to 1300-000-0000

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

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