General discussion

Locked

Phone Number format

By adr1817 ·
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

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Here's how to do it

by TechExec2 In reply to Phone Number format

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

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums