Formating a date field

[citizenrain]

I have a date field that is formated with the year(YYYY)-month(MM)-day(dd) I would like the 2008-01-11 to be displayed Friday, January 11, 2008.

 

[dave3009]

Hi citizenrain

Welcome to the board

Custom format ddd, mmmm, dd, yyyy ought to do you right

HTH


Dave

 

[VoG]

Try a Custom format

dddd, mmmm dd, yyyy

 

[citizenrain]

neither of these work.

The date is in a pivot table the data is coming from an oracle database.

 

[VoG]

Perhaps it is a 'text date'. Select the date(s), Data > Text to columns. Click Next twice to take you to the 3rd screen. Check Date and select YMD on the drop-down, then click Finish. That should convert it to a 'real' date and the custom formatting should work.

 

[citizenrain]

I import the data from the database into a worksheet then query the data to make pivot tables. I have tried formating the imported data but nothing happens. My guess is that i have to somehow convert the data to something that excel understands.