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
> >

>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" <(E-Mail Removed)> wrote in message
news:783D01EC-22A7-4444-905F-(E-Mail Removed)...
> 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
> >

Try this:

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