Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: HELP!! My spreadsheet dates are messed up!

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I don't have alot of experience with Excel, but my boss is having me prepare a spreadsheet consisting of a list of documents that are numbered and dated.

    When I saved my document and exited out of Excel to check something in another program, when I came back, my dates had been converted to numbers.
    Example: 12/28/93 is now 34331!!!

    I can double click the number and get the date, but when I leave the cell, it converts back to the number again! What have I done?! He wants this document done by 5:00 p.m. and I'm only 1/2 way through!

  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Format the cell where you have a number representing a date with FORMAT|CELLS|NUMBER|DATE and choose one of the various options to represent date!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Choose the Tools | Options... menu command and uncheck the "Formula" Window options check box on the View tab

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Good point Mark! --
    If his sheet has some how been set to show Formulas, formatting any cells will not help.

    Regards!

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    A Mile High!!
    Posts
    241
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Another way to change back instead of using the tools menu is ctrl+~. I find a lot of users are trying to use keyboard shortcuts and inadvertantly hit keys. Doh!!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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