Most likely 9999999999 is stored in your column as texts not numbers.
First convert them to numbers then use phone number format.
To convert to numbers, try this:
1) In any cell type number 1;
2) Press Ctrl+C to copy the cell;
3) Select the whole range which contains the text which you want to convert
to numbers;
4) Go to menu: Edit/Paste Special, check Paste - Values, Operation -
Multiple.
This will multiply all cells by 1 and automatically convert those texts into
numbers.
--
Best regards,
---
Yongjun CHEN
www.XLDataSoft.com
=================================
"tfanatik" wrote in message
...
I can't get a column of numbers, 9999999999, to format as a phone number,
(999) 999-9999. I've tried phone number format, as well as what I found in
this discussion group and nothing has worked. Any new suggestions?