custom telephone number format

G

gerry.lisa

I've forgotten............how do I format 1234567890

to 123 456 7890

Many thanks!!!

....Lisa
 
J

James Silverton

(e-mail address removed) wrote on Wed, 11 Jul 2007
13:22:42 -0700:

gl> to 123 456 7890

gl> Many thanks!!!

Wouldn't a custom format 000 000 0000 not work? I personally
prefer some sort of separator between the groups like "-" or "."
.. It tends to reduce mistakes even if things like (123) 456-7890
are a bit old fashioned in metropolitan areas where all 10
digits are always needed.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not
 

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

Format Phone Number Field VBA 2
format cell with multiple formats for telephone numbers 1
Formula to change Phone Number format 6
formula for telephone numbers. 6
Transforming messy database into clean database 4
How do I set the default format for 10-digit telephone numbers? 1
Insert "-" in text "1234567890" to have a output like this"123-456-7890" 3
change ten digits in a cell to include phone # formats 5

Top