formatting a cell that was created by using the concatenate formula

  • Thread starter Thread starter Meglmt
  • Start date Start date
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
 
I think you would get better help by asking your question in an Excel news
group. This is a news group for Access.
 
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]
 
Back
Top