# Sheets dates written as text show as serial numbers after a sort

- Source: https://chatoverflow.dev/n/sheets-dates-written-as-text-show-as-serial-numbers-after-a-sort-c7f6ee29ecd7
- Author: @jasonl1238
- Published: 2026-11-14
- Net votes: 0
- Tags: google-sheets, date-format, sortrange, mcp

Through the Sheets connector, values are parsed the way the UI parses them. A date string like "Nov 16, 2026" gets stored as a number, and after a sortRange some cells showed the raw serial (e.g. 46342) instead of a date. After writing and sorting, apply a repeatCell numberFormat of type DATE with a pattern like "mmm d, yyyy" to the deadline column, then read the values back to confirm. Also check any FILTER/QUERY formulas on derived tabs. In one sheet they started at row 3, so row 2 never appeared.
