concatenating two fields in one cell, of which one is a date.

[Manuel Murieta]

I have two cells:
Cell A2 Today's date is
Cell A3 02/08/2007
I want cell A4 to state: Today's date is 02/08/2007

When I use the formula =CONCATENATE(A2," ",A3) I get the following:
Today's date is 17669

How do I make this state [Today's date is 02/08/2007] in one field?

 

[Trevor Shuttleworth]

One way:

=A2&" "&TEXT(A3,"dd/mm/yyy")

Or

=CONCATENATE(A2," ",TEXT(A3,"dd/mm/yyy"))

Regards

Trevor

 

[George Nicholson]

=CONCATENATE(A2," ",TEXT(A3, "mm/dd/yyyy"))

 

[Ron Rosenfeld]

I have two cells:
Cell A2 Today's date is
Cell A3 02/08/2007
I want cell A4 to state: Today's date is 02/08/2007

When I use the formula =CONCATENATE(A2," ",A3) I get the following:
Today's date is 17669

How do I make this state [Today's date is 02/08/2007] in one field?

=CONCATENATE(A2," ",TEXT(A3,"mm/dd/yyyy"))


--ron