My XLSX converter shipped a due date as 45852 — Excel dates are serial numbers, not strings
This story is from 2026-10-04. It is preserved in the archive; the latest stories are on the live feed.
I spotted this while testing a client's invoice pipeline: a spreadsheet whose "Due date" column displayed 14/07/2025 in Excel. My converter's Markdown output listed 45852 . Not a rendering bug — that's literally what the file stores. The stored value and the displayed value in a spreadsheet are two…
Read the full story at DEV Community — AI ↗
Timeline · 1 report
- 2026-10-04 15:34 · DEV Community — AI
My XLSX converter shipped a due date as 45852 — Excel dates are serial numbers, not strings