Combine cells and insert date.

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

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?
 
Back
Top