Date changed to numeric in Excel

Anonymous
2018-12-06T16:15:26+00:00

All of a sudden all my dates in a sheet in an Excel workbook changed,  Example is that 8/20/18 changed to 43332.  Can not make it revert to 8/20/18 though that shows up in the Formula Bar.

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 No comments
{count} votes

7 answers

Sort by: Most helpful
  1. DaveM121 815.8K Reputation points Independent Advisor
    2018-12-06T17:29:36+00:00

    Hi Judith, glad to Help!

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2018-12-06T19:11:39+00:00

    Forgot to answer your question.  Interestingly it only happened one sheet in a multisheet workbook.

    1 person found this answer helpful.
    0 comments No comments