View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay Dean Jay Dean is offline
external usenet poster
 
Posts: 154
Default FORMATING PHONE NUMBER!!

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 ***