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.

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" wrote:
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.

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

"SJT" wrote:

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.

Thank you very much.

"Max" wrote:

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" wrote:
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.

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

"smartgal" wrote:

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

"SJT" wrote:

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.

Welcome ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000, Files:362, Subscribers:62
xdemechanik
---
"SJT" wrote
Thank you very much.

=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??
"smartgal" wrote:

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

"SJT" wrote:

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.

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


Gord Dibben MS Excel MVP


On Thu, 18 Feb 2010 15:46:01 -0800, Warren Jo
wrote:

=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??
"smartgal" wrote:

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

"SJT" wrote:

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.