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