how to put dashes in a number 13000000000 to 1300-000-0000
R Robert_DubYa May 22, 2007 #2 =LEFT(A1,4)&"-"&MID(A1,5,3)&"-"&RIGHT(A1,4) the above is if A1 contains your value.
P Peo Sjoblom May 22, 2007 #3 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
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
