formatting a cell that was created by using the concatenate formula

M

Meglmt

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
 
K

Klatuu

I think you would get better help by asking your question in an Excel news
group. This is a news group for Access.
 
J

John Vinson

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
Click to expand...

You may want to post this question on an Excel newsgroup. This
newsgroup is for a different program, Microsoft Access.

John W. Vinson[MVP]
 
Top