Fix an error
Fix a date that shows as a number
What to do
- Select the cell.
- Press Ctrl+1.
- Choose Date and click OK.
Good to know
- Excel stores each date as a count of days since 1900.
- The value is correct, and only the look needs changing.
The idea in general
Underneath, a date is a plain count of days.
What I assumed
- You are using Excel on a computer. Menus can look a little different on a Mac or in a browser.