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