Hi,
I am trying to date Concatenate 2 cells. One contains text the other date.
How can I get the date to display as a date?
=T6&" "&U6 returns ESTIMATE 40066

That's because the CONCATENATE formula joins two text strings together.
The result you are getting is converting the date 10/09/2009 (UK) into text.
Perhaps you should approach from another angle.
What are you trying to achieve? Why do you need to join these two cells in
this way?

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"gb_S49" wrote:

Hi,
I am trying to date Concatenate 2 cells. One contains text the other date.
How can I get the date to display as a date?
=T6&" "&U6 returns ESTIMATE 40066

I need to know the date of a movement for a report. The colomns contain over
2,000 rows.

"Russell Dawson" wrote:

That's because the CONCATENATE formula joins two text strings together.
The result you are getting is converting the date 10/09/2009 (UK) into text.
Perhaps you should approach from another angle.
What are you trying to achieve? Why do you need to join these two cells in
this way?

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"gb_S49" wrote:

Hi,
I am trying to date Concatenate 2 cells. One contains text the other date.
How can I get the date to display as a date?
=T6&" "&U6 returns ESTIMATE 40066

Try this:

=T6&" " &TEXT(U6,"dd/mm/yyyy")

Please try to give a fuller explanation of what it is you are doing.

Data origin/destination. Reasons. Examples. Etc.

The more info you can give the easier it will be to assist.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"gb_S49" wrote:

I need to know the date of a movement for a report. The colomns contain over
2,000 rows.

"Russell Dawson" wrote:

That's because the CONCATENATE formula joins two text strings together.
The result you are getting is converting the date 10/09/2009 (UK) into text.
Perhaps you should approach from another angle.
What are you trying to achieve? Why do you need to join these two cells in
this way?

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"gb_S49" wrote:

Hi,
I am trying to date Concatenate 2 cells. One contains text the other date.
How can I get the date to display as a date?
=T6&" "&U6 returns ESTIMATE 40066

Thanks for your assistance but now sorted
:-)
ESTIMATE 08,Apr 2010
=T20&" "&TEXT(U20,"dd,MMM yyyy")


"Russell Dawson" wrote:

That's because the CONCATENATE formula joins two text strings together.
The result you are getting is converting the date 10/09/2009 (UK) into text.
Perhaps you should approach from another angle.
What are you trying to achieve? Why do you need to join these two cells in
this way?

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"gb_S49" wrote:

Hi,
I am trying to date Concatenate 2 cells. One contains text the other date.
How can I get the date to display as a date?
=T6&" "&U6 returns ESTIMATE 40066

How can I get the date to display as a date?
=T6&" "&U6 returns ESTIMATE 40066

For the date in m/d/yyyy format...

=T6&" "&TEXT(U6,"m/d/yyyy")

--
Biff
Microsoft Excel MVP


"gb_S49" wrote in message
...
Hi,
I am trying to date Concatenate 2 cells. One contains text the other date.
How can I get the date to display as a date?
=T6&" "&U6 returns ESTIMATE 40066