concatenating two fields in one cell, of which one is a 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?
 
T

Trevor Shuttleworth

One way:

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

Or

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

Regards

Trevor
 
R

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

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


--ron
 

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

Conditional Formatting 1
Cell Formatting 2
Find Cell with Today's Date 4
Date Formulas & format 3
Year + week => first date of week 9
Macro to extract few values from a cell 3
Blank Cells 3
Date started and finished question? 2

Top