Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format phone numbers with an 800
Hello I have a column formatted as phone number using format-cells-
special-phone number. the problem is if the phone number is an 800 number the formatting is not right. for example is the number is 800-212-543-6543 it gives me (800212) 543-6543 if the number does not have the 800 then is correct. How can I format the same cell so if there is an 800 number to read 800- 123 -123- 1234 or if there is no 800 to read 123- 123 -1234 thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
format phone numbers with an 800
Try this custom format...
[9999999999] ###-###-###-####;###-###-#### -- HTH... Jim Thomlinson "Wanna Learn" wrote: Hello I have a column formatted as phone number using format-cells- special-phone number. the problem is if the phone number is an 800 number the formatting is not right. for example is the number is 800-212-543-6543 it gives me (800212) 543-6543 if the number does not have the 800 then is correct. How can I format the same cell so if there is an 800 number to read 800- 123 -123- 1234 or if there is no 800 to read 123- 123 -1234 thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
format phone numbers with an 800
HUH?!?!? What country are you in? The formatting of your phone numbers
suggests you are in USA/Canada. 800 numbers in USA/Canada essentially have an area code of 800, 866, 877, 888, etc... Valid 800 numbers...and other phone numbers: (800) 212-6543...or...800-212-6543 (800) 543-6543...or...800-543-6543 (212) 543-6543...or...212-543-6543 Invalid phone number: 800-212-543-5643 Is there an extention included?...ext. 643? HTH, Conan Kelly "Wanna Learn" wrote in message ... Hello I have a column formatted as phone number using format-cells- special-phone number. the problem is if the phone number is an 800 number the formatting is not right. for example is the number is 800-212-543-6543 it gives me (800212) 543-6543 if the number does not have the 800 then is correct. How can I format the same cell so if there is an 800 number to read 800- 123 -123- 1234 or if there is no 800 to read 123- 123 -1234 thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format phone numbers with periods | New Users to Excel | |||
Format phone numbers to look the same | Excel Discussion (Misc queries) | |||
How do I format phone numbers in excel? | Excel Discussion (Misc queries) | |||
Format sequence for phone numbers? | Excel Discussion (Misc queries) | |||
change format for phone numbers automatically | Excel Worksheet Functions |