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

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.
 
T

T. Valko

Try something like this...

A1 = Today is
B1 = 12/21/2009

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

Returns: Today is December 21, 2009
 
F

Fred Smith

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

Excel is seeing the date as dd/mm/yyyy 4
Converting mm/dd/yyyy to yyyy/mm/dd 6
Formula to display nearest following Thursday in mm/dd/yyyy format 1
converting dd/mm/yy to mm/dd/yyyy 3
Month (MMM) from date (dd/mmm/yy) 1
Splitting dd/mm/yyyy hh:mm 2
Date Conversion dd.mm.yyyy to dd/mm/yyyy 1
Returning the month (mmm) from cell in date format dd/mm/yyyy 1

Top