Custom Cell Format

[FredGarvin]

Does anyone happen to know the format string that Excel uses to create it's special format for US telephone numbers?

The reason I am asking is that I am trying to use the same mask but in a different application and can not get that to work right. I have tried using "("###")"_###"-"#### but that doesn't work.

Any tips? Thanks!

 

[onlyadrafter]

Hello,

I have this as a preset try

[<=9999999]###-####;(###)###-####

seems to work for me.

----------------------------------
Hope this helps.
----------------------------------

maybe only a drafter
but the best user at this company!

 

[onlyadrafter]

Hello,

you could just use

(###)"_"###-#### as well, if the numbers are entered correctly. Excuse the lack of knowledge of US phone numbers, I am in the UK.



----------------------------------
Hope this helps.
----------------------------------

maybe only a drafter
but the best user at this company!

 

[FredGarvin]

Thanks for the help you guys. I could have sworn I tried that, but when I went back and tried it it worked.