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

[Maverick50]

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

 

[smartin]

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.

 

[T. Valko]

**Maybe** this custom format:

000\-000\-0000

Or, using a formula in a helper cell:

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