Why not just format the original column?

If you really want the dashes (i.e., as part if the text entry vs a
number entry) then parse out the number & add the dashes:

=LEFT(A1,3)&"-"&MID(A1,3,4)&"-"&RIGHT(A1,4)

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=527850