Combine cells and insert date.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J.W. Aldridge - 02 Nov 2006 20:24 GMT

I have a formula in which i am combining text from various cells.
=CONCATENATE(G3,G4,G8,G9,G10,G11,G12)
In this case, one cell (G9) contains the date formula =TODAY().
What I am getting from G9 is 39023. What I need is the actual value
11/02/2006 from the results of the formula (will change cell format to
get actual yyyyddmm format)

Any advice?

Reply to this Message

Bob Umlas - 02 Nov 2006 20:49 GMT

=G3&G4&G8&TEXT(G9,"mm/dd/yyyy")&G10&G11&G12
Bob Umlas
Excel MVP

> I have a formula in which i am combining text from various cells.
> =CONCATENATE(G3,G4,G8,G9,G10,G11,G12)
[quoted text clipped - 4 lines]
>
> Any advice?

Reply to this Message