baggins22
03-10-2007, 04:12 PM
Hey everybody,
i have a list of numbers, some foreign and some domestic
i want to be able to enter a string of numbers and have it format the cell accordingly.
Ex.
if i enter 5555555555 it will look like (555)555-5555
but if i enter a foreign number : 912255555555 i want it to look like 91 (22) 5555-5555
Im not sure if this is possible, if necessary i will add another column with a "d" (for domestic) or a "I"( for international). In this case would it be possible to do a IF statement?
Ex. If "D" use (555)555-5555 Format
IF "I" use 91 (22) 5555-5555 Format
i have a list of numbers, some foreign and some domestic
i want to be able to enter a string of numbers and have it format the cell accordingly.
Ex.
if i enter 5555555555 it will look like (555)555-5555
but if i enter a foreign number : 912255555555 i want it to look like 91 (22) 5555-5555
Im not sure if this is possible, if necessary i will add another column with a "d" (for domestic) or a "I"( for international). In this case would it be possible to do a IF statement?
Ex. If "D" use (555)555-5555 Format
IF "I" use 91 (22) 5555-5555 Format