This is a common problem:

if 1234569876 is a number then Format Cells... Special Phone Number
will work. It won't work if 1234569876 is a text string.

If 1234569876 is a text string in say A1 then use =value(A1) and format it.
--
Gary''s Student


" wrote:

Hi,


I'm trying to format a column of cells that were created by combining 2
different cells using concatenate command.


The result is a phone number, but when I go to format it (so it
displays as a phone number (###) ###-####), nothing happens.


I'm using Excel 97 (don't laugh), but this is the case on XP as well


Thanks




--
Meg Darnell, LMT, CD
Director of Alumni Services
Swedish Institute College of Health Sciences
212-924-5900 x142