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 |
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 |