Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Phone Numbers in a Merged Cells... | Excel Discussion (Misc queries) | |||
Hightlighting Numbers & then all Cells to the right of these Numbers. | Excel Worksheet Functions | |||
How to alter data on HTML webpage into Excell cells as numbers? | New Users to Excel | |||
Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions |