Change the concatenate formula to put the format

=TEXT(A1&B1,"format")

--

HTH

RP
(remove nothere from the email address if mailing direct)


" wrote in
message ...
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