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

[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. Valko]

Try something like this...

A1 = Today is
B1 = 12/21/2009

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

Returns: Today is December 21, 2009

 

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