M
mzehr
Hi Misty,
2 methods that I can think of,
one is to format the number using a custom format ###-###-
####,
Another is using a formula to concoctenate the text,
assuming that the value is in a5, use =LEFT(A5,3)&"-"&MID
(A5,4,3)&"-"&RIGHT(A5,4)
HTH
2 methods that I can think of,
one is to format the number using a custom format ###-###-
####,
Another is using a formula to concoctenate the text,
assuming that the value is in a5, use =LEFT(A5,3)&"-"&MID
(A5,4,3)&"-"&RIGHT(A5,4)
HTH