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 Excel
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Check my date columns →

Why this happens

How to fix it

  1. 1Select the column and choose a Date format (Ctrl+1 → Date).
  2. 2For imports, write dates as text in YYYY-MM-DD.
  3. 3Check a few rows against the original — never guess dates that look ambiguous.

Related guides

Still stuck? Ask SheetFix Support