Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Oct 2001
    Location
    Blakeslee, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Showing Days of the Week in Date Format (Excel

    Custom format the date cells as

    dddd, mmmm dd, yyyy
    Microsoft MVP - Excel

  3. #3
    Star Lounger
    Join Date
    Oct 2001
    Location
    Blakeslee, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Showing Days of the Week in Date Format (Excel

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •