View Single Post
  #1   Report Post  
Judi Mason
 
Posts: n/a
Default change ten digits in a cell to include phone # formats

I need to change a cell with ten digits to include the phone number format
characters. Not just in the "view", but in the actual cell. The cell needs
to be changed from "1234567890" to "(123) 456-7890", including the space
after the area code. I am importing an excel file of phone numbers and the
contents need to be exact. Any suggestions?