How to create a specific phone number format

A

Access Joe

Hey everyone,

In a column that will contain phone numbers, how do you create the following
format for the numbers:

###.###.####

I've tried doing this in the Custom option of the Format Cells box, but it
doesn't work. I know I can type something like (###) ###-#### and that will
work fine. But that isn't the format I want. I need the periods.

This is a new worksheet - no phone numbers have been entered yet. Excel 2003

Thanks everyone!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you remove phone format???? 2
Formating phone numbers in cells 2
Newbie Phone Format Problem 6
Format phone numbers to look the same 1
want to change phone format ***-***-**** to 1********** 2
Phone number not 2
Convert number to phone number 1
Converting data in column to Phone Format 1

Top