Concatenate

[SJT]

I am attempting to use the concatenate function to combine some text with
dates from two different cells. However, the result gives me the serial
number associated w/ the date as opposed to the format "October 16, 2008".
The cell is formatted as a date. I am using Excel 2003 in XP. Thank you in
advance for your assistance.

 

[Max]

Use the TEXT function to specify the date format that you want
eg In B1: = TEXT(A1,"mmmm dd, yyyy")
where A1 houses a date
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik

 

[smartgal]

Can you provide samples of the data you're trying to concatenate, and show
how you'd like the result to display?

 

[SJT]

Thank you very much.

Use the TEXT function to specify the date format that you want
eg In B1: = TEXT(A1,"mmmm dd, yyyy")
where A1 houses a date
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik

 

[SJT]

Thanks for the help but someone already responded to my post.

 

[Max]

Welcome ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000, Files:362, Subscribers:62
xdemechanik

 

[Warren Jo]

=CONCATENATE(G45," ",C45," ",D45," ",E45)
This is the formula I've used. E45 is a date. I've tried using 'TEXT' in
the formula but keep getting an error message. Can someone write me a
formula??

 

[Gord Dibben]

=G45 & " " & c45 & " " & D45 & " " & TEXT(E45,"mmmm dd, yyyy")


Gord Dibben MS Excel MVP