How do I change Phone: 8153381667 to Phone: 815-338-1667
 

How do I change Phone: 8153381667 to Phone: 815-338-1667

How do I change Phone: 8153381667 to Phone: 815-338-1667
 

Maverick50 wrote:
How do I change Phone: 815xxxyyyy to Phone: 815-xxx-yyyy

Take a look a format | cells in the "special" category. There is
something very close and easily modified.

BTW I don't know if you intended to post a real phone#, but be aware
these things are easily googled for a name, address, and in this case,
photograph taken from the road.

How do I change Phone: 8153381667 to Phone: 815-338-1667
 

**Maybe** this custom format:

000\-000\-0000

Or, using a formula in a helper cell:

=TEXT(A1,"000\-000\-0000")

--
Biff
Microsoft Excel MVP


"Maverick50" wrote in message
...
How do I change Phone: 8153381667 to Phone: 815-338-1667