Share via

Excel changing my dates to numbers

Anonymous
2020-06-11T10:32:48+00:00

Hi there! I had a spreadsheet done up in the above format, with several different dates in the "expires" column. I pressed something on my keyboard by accident and now I have a series of 5 digit numbers instead, but the date remains in the formula bar. I've tried formatting the cell back to date and nothing happens. Help!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2020-06-11T10:48:13+00:00

    Good Day!

    This is Ivan, an independent advisor and a fellow Microsoft Excel User.

    Can you try this:

    Press CTRL + ` (grave accent).

    This toggles if formulas are to be displayed or hidden, and also affects how dates are displayed.

    Here's a link to about the control:

    https://support.office.com/en-us/article/Displa...

    Kindly let me know if you have questions. thanks!

    69 people found this answer helpful.
    0 comments
Answer accepted by question author
  1. Anonymous
    2020-06-11T10:40:51+00:00

    It looks like you are in View Formulas mode.

    Try tapping Ctrl+(the is just left of the 1 in the upper left of the keyboard).

    58 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-06-11T10:48:19+00:00

    You're a lifesaver, thanks so much that worked perfectly!

    0 comments