Showing Days of the Week in Date Format (Excel 2000)

Topic

New Reply

Hi all. I need some help and I know it is probably something easy. I have an Access Database that has a date field in it that is formatted with a Long Date EX: Sunday, January 13, 2002 I am using Excel and linking for information to the database and one of the pieces of information I need is the long date. I can’t seem to figure out though how to get Excel to Show anything other than January 13, 2002 and I need the day of the week to show up in my Spreadsheet too. ANy help would be greatly appreciated. Thanks in advance for any help.

Reply | Quote

Replies

Custom format the date cells as

dddd, mmmm dd, yyyy

Reply | Quote

Thank you I knew it was something really simple I was just overlooking.

Reply | Quote