combine text & date formula to show mmmm dd, yyyy?

  • Thread starter Thread starter htm_temp1
  • Start date Start date
H

htm_temp1

How do I combine text and date formula to show the written date and not the
Excel number date? I have text in a couple of cells and a date formula in
another cell(input from a different worksheet). I have the formula =A3 & F3
& A4 in A1 and would like it to read: We went to the station on December 21,
2009 and took the train. However, it is reading We went to the station on
40168 and took the train.
Thanks.
 
Try something like this...

A1 = Today is
B1 = 12/21/2009

=A1&" "&TEXT(B1,"mmmm dd, yyyy")

Returns: Today is December 21, 2009
 
You need the Text function to convert the date to the format you want. Use:
=a3&text(f3,"mmmm dd, yyyy")&a4

Regards,
Fred.
 

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

Formula to display nearest following Thursday in mm/dd/yyyy format 1
Excel is seeing the date as dd/mm/yyyy 4
convert date mm/dd/yyyy to dd/mm/yyyy 2
Converting mm/dd/yyyy to yyyy/mm/dd 6
Month (MMM) from date (dd/mmm/yy) 1
Splitting dd/mm/yyyy hh:mm 2
converting dd/mm/yy to mm/dd/yyyy 3
combining dates and text in a cell 1

Back
Top