Formating phone numbers in cells

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!

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:

>
> 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!
>
>
> --
> jloughmiller
> ------------------------------------------------------------------------
> jloughmiller's Profile: http://www.excelforum.com/member.php...o&userid=36502
> View this thread: http://www.excelforum.com/showthread...hreadid=562615
>
>

Originally Posted by Marcelo

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

>[/color]

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!