Formating phone numbers in cells


J

jloughmiller

Our office recently changed the format we use for phone numbers - from
dashes to periods. I want to make a custom format for cells so that
even if I slip and use dashes in the phone number, Excel will know to
display the phone number with periods. I can't find the way to type
the format so that Excel will accept it and to make the changes. Any
help would be appreciated!
 
Ad

Advertisements

G

Guest

Hi,

format as custom ####"."#### (the quantity of digits on this format is on
Brazilian phone number, adjust as your needs)

hth
regards from Brazil
Marcelo

"jloughmiller" escreveu:
 
Ad

Advertisements

J

jloughmiller

Marcelo said:
format as custom ####"."#### (the quantity of digits on this format
is on
Brazilian phone number, adjust as your needs)
[/QUOTE]


That does work if I don't use hyphens to type in the number. If I just
type in the string of numbers using that Custom Format, it will insert
the periods. That's great...thanks.


Is there anyway that excel will know to replace hyphens with periods in
that cell without using the "Replace" tool? If not, this method will be
sufficient.


Thanks again, Marcelo!
 

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

Top