If you'll right click on the cell or cells in question, select Format
Cells, then Custom. Copy the text string below into your Clipboard,
then paste it into the Type textbox that appears in that window.

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

Does that solve the problem?

Dave O
Eschew obfuscation