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

  • Thread starter Thread starter Manuel Murieta
  • Start date Start date
M

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?
 
One way:

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

Or

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

Regards

Trevor
 
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?
Click to expand...

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


--ron
 
Back
Top