Custom Cell Format for Phone numbers

Grrr, I thought I had it - but no....
whichever way I try, I get any 2 of the required formats to display correctly - but not the 3rd...

I don't mind if the number 000-000-00000 (5 digits in last set) has to be : 000-000-000-00, if that helps - but want to keep the other numbers dsplaying format 000-000-0000 or 000-000-000

Hope you can help!

Cheers
Anne

Originally Posted by annieb

I've just found some of the numbers I'm having to enter, have an extra zero on the end - so:
000-000-00000

[already have 000-000-000 and 000-000-0000 which format perfectly now, with the code you provided]

Is that code able to be expanded to allow fro the extra possible digit?

Add a 2nd rule:

[>999999999]000-000-00000;[>99999999]000-000-0000;000-000-000