Excel dates turn into numbers like 45290 — how to get the dates back
Why dates become five-digit serial numbers after export or copy-paste, and how to display them correctly again.
The message you see
Dates show as numbers like 45290 in ExcelFastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- Excel stores dates as day counts since 1 January 1900; the date format was lost.
- The column was pasted as values or exported without formatting.
How to fix it
- 1Select the column and choose a Date format (Ctrl+1 → Date).
- 2For imports, write dates as text in YYYY-MM-DD.
- 3Check a few rows against the original — never guess dates that look ambiguous.
Related guides
Excel
“Excel cannot open the file because the file format or file extension is not valid”
ExcelExcel error “SYLK: File format is not valid” when opening a CSV
Excel“We found a problem with some content” — Excel workbook won't open properly
Still stuck? Ask SheetFix Support