custom format for phone numbers

[Guest]

I want to use a custom format for phone numbers, the one excel has uses () I want to use –
Ex. Numbers entered as 2222222 1232222222 18002222222 should be formatted as 222-2222 123-222-2222 1-800-222-2222. Can this be done by a custom format? I have tried to modified the format for phone numbers but cant get it to work. Thanks

 

[Mark W.]

On 2002-03-13 07:43, Anonymous wrote:
Sorry for the confusion, they are three different numbers, showing if somebody enters a local number (2222222), area code and number(1232222222), or 1 area code and number(11232222222)

Ahhh, sorry for being so literal. Try this...

[<=9999999]###-####;[>10000000000]#-###-###-####;###-###-####

 

[Guest]

Mark, tried that I get Excel cannot use the number format you typed, I retyped it 3 times to make sure, BTW I am using '97 if this matters

 

[Mark W.]

On 2002-03-13 08:46, Anonymous wrote:
Mark, tried that I get Excel cannot use the number format you typed, I retyped it 3 times to make sure, BTW I am using '97 if this matters

I copied it from the input field. Try pasting it.
This message was edited by Mark W. on 2002-03-13 11:12

 

[Guest]

Ok that works, I was trying to right click and paste works with control V, Thanks