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

How do I change Phone: 8153381667 to Phone: 815-338-1667
0
1/23/2009 2:29:01 AM
excel.newusers 15348 articles. 2 followers. Follow

2 Replies
480 Views

Similar Articles

[PageSpeed] 7

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.
0
smartin108 (170)
1/23/2009 2:46:44 AM
**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" <Maverick50@discussions.microsoft.com> wrote in message 
news:FE202E11-02DC-4F22-8BA0-70139001608E@microsoft.com...
> How do I change Phone: 8153381667 to Phone: 815-338-1667 


0
biffinpitt (3172)
1/23/2009 2:49:42 AM
Reply:

Similar Artilces: