Phone number formatting using periods

ssblue
ssblue used Ask the Experts™
on
Excel  -  Need help getting the following formula working. Formatting for a phone number using periods.

  =TEXT(A31,"###. ###.####")

A31  =  1111111111

wanting  =   111.111.1111
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Director of Technology Development, IPM
Commented:
You must escape the periods:
=TEXT(A31,"000\.000\.0000")

Open in new window

ssblueCoordinator

Author

Commented:
Perfect, thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial