1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel Dates showing incorrectly

Discussion in 'Business Applications' started by Gogs, Sep 30, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. Gogs

    Gogs Thread Starter

    Joined:
    Jul 28, 2003
    Messages:
    121
    Hya folks,

    Posting this on behalf of a colleague. She has a spreadsheet set up which includes dates. She "doesn't know what she's done" but all of the dates are showing in numerical form ie: 36790 instead of date format ie. dd/mm/yy.

    Excel shows the number in the cell but in the formula bar it shows the date correctly. I've tried changed the format of the cell (and even the whole sheet) to Date - dd/mm/yy but still to no avail. I've also made sure the regional settings for the PC are correct in case that was throwing it out. Even checked it's not using the 1904 date system.

    Yesterday the spreadsheet was working fine but today kaput!!

    Any help greatly appreciated.

    Gogs
     
  2. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Try hitting the key below ESC while holding down CTRL.

    Or use Format Painter to copy from a correctly formatted cell, in another file if necessary.

    If still stuck, PM me to arrange sending a chunk of the file.

    Rgds,
    Andy
     
  3. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Have her put a 1 in any other cell. Copy it.
    Choose the cells with bad dates.
    Hit Edit-Paste special, Choose Multiply. Ok.

    NOW, format again as mm/dd/yyyy or whatever.

    It could be that Excel is seeing the numbers as text, and this should force seeing the numbers as numbers, which are formattable as dates.
     
  4. Gogs

    Gogs Thread Starter

    Joined:
    Jul 28, 2003
    Messages:
    121
    Thank you both for the advice. I tried Andy's first and it worked. :)

    Gogs
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/168517

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice