formatting a cell that was created by using the concatenate formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Meglmt - 28 Nov 2005 19:39 GMT

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

Reply to this Message

Klatuu - 28 Nov 2005 20:17 GMT

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

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

John Vinson - 28 Nov 2005 21:23 GMT

>Hi,
>
[quoted text clipped - 7 lines]
>
>Thanks

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

John W. Vinson[MVP]

Reply to this Message