Concatenate including a date so that the date appears as a date

  • Thread starter Thread starter Zembu
  • Start date Start date
Z

Zembu

When I try to join the contents of several cells, one of which is a date and
time obtained from =now(), the date and time part appears as a number. How
can I make it appear as a date and time? I have tried changing the cell
formats - probably there is a combination that works but I haven't found it.
I also tried copying the original date cell to another cell and changing the
latter cell's format and concatenating using that latter cell, but still no
success.
 
Use the TEXT function. For example, =TEXT(NOW(),"mmmm d, yyyy") would give
January 6, 2010
"ddd mm-dd-yy" would give Wed 01-06-10,
etc.
 
Try this...

A1 = Today's date is

=A1&" "&TEXT(NOW(),"m/d/yyyy h:mm AM/PM")

Will return something like:

Today's date is 1/6/2010 1:08 PM
 

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

date Concatenation 4
Concatenate data that includes dates 5
Concatenate a date and name 2
help with format change of date part of concatenate formula 1
Special string convertion to date and time 4
Help with Concatenation 3
Excel Average dates help 0
Date/Time 1

Back
Top