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.