Software

Ask something
Discussion Locked

Phone Number format

0 helpful
1 reply

by adr1817

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

All,

I have excel worksheet and one of the columns is a phone number but i have at least 500 phone numbers in a plain number not phone number format.
How can I fix that whole column to format (are code) 111 - 1234?
Thank you for the help

1 reply

by techexec2

Select cells to be formatted, then Format (menu) -> Cells (menu) -> Number (tab) -> Special (category) -> Phone Number (type) -> OK (button).

This discussion is closed to new replies.