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!


--
jloughmiller
------------------------------------------------------------------------
jloughmiller's Profile: http://www.excelforum.com/member.php...o&userid=36502
View this thread: http://www.excelforum.com/showthread...hreadid=562615

Formating phone numbers in cells
 

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

Formating phone numbers in cells
 

Marcelo Wrote:


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!


--
jloughmiller
------------------------------------------------------------------------
jloughmiller's Profile: http://www.excelforum.com/member.php...o&userid=36502
View this thread: http://www.excelforum.com/showthread...hreadid=562615