Problem formatting for phone number

  • Thread starter Thread starter rutledj
  • Start date Start date
R

rutledj

Can anyone tell me how to use the cell validation or some other method
to put the numbers entered in a cell in a proper phone number format?
(###) ###-####


Thanks,
Rut
 
Let your user type in the phone number (as a number).

Then use Format|Cells|number tab|Special|Phone Number.
 
Back
Top