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

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.

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

Try something like this...

A1 = Today is
B1 = 12/21/2009

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

Returns: Today is December 21, 2009

--
Biff
Microsoft Excel MVP


"htm_temp1" wrote in message
...
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.

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

=today() in Cell A1
="We went to the station on "&TEXT(A1,"mmmm dd, yyyy")&"and took the train."
in Cell C1


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"htm_temp1" wrote:

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.

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

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

Regards,
Fred.

"htm_temp1" wrote in message
...
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.