Combine cells and insert 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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find the last 4 cell entries in a row 2
find first empty cell in range and then copy from another workbook 1
An easier way? 9
help of VBA 1
Forecast v actual - row addition problem 2
Show dates based on criteria 3
Ongoing Issue - I have tried to clarify so that you understand 7
Trying to get a Boolean formula to work month-to-month 4

Top