Select Format/Cells from Excel's menu bar, select the Number tab on the
dialog box that comes up, select Custom from the Category list and then put
this into the Type field...

000-000-0000

--
Rick (MVP - Excel)


"jay dean" wrote in message
...
In Range("H2") is a 10-digit number. How do I format the cell to show
the number in the format ###-###-####. Example: Entering 1478942266
should convert to 147-894-2266.

Any help would be appreciated!
Jay

*** Sent via Developersdex http://www.developersdex.com ***