Stop Excel from turning text into dates

Keep shipment windows, ranges and letter-number codes as text instead of spreadsheet dates.

A date is a type decision, not a polite rewrite

Leading zeros are a different injury. The leading-zero guide is about identifiers such as 00127 that a spreadsheet stores as the number 127. This page is about text that Excel’s general rules treat as a date or a fraction: a ship window, a ratio, a range, or a short code made of letters and digits. The characters look meaningful to a person and convenient to a parser that is eager to help.

Microsoft documents several of those automatic conversions. A slash or a hyphen in a numeric-looking entry can become a date. A continuous run of letters and numbers, such as a month token glued to a day, can become a date as well. Current Microsoft 365 builds expose switches under automatic data conversions, including one for letter-and-number strings, and the help text says values that also contain spaces or extra punctuation may still be treated as dates. Those switches are not in the CSV file. They are in the Excel installation that opens it. Another machine can convert a cell yours left alone.

There is a second, quieter loss. Excel dates are serial numbers underneath a format. Once 03/04/2026 has become a serial, the original characters are gone. You cannot tell whether the source meant the third of April or the fourth of March. Formatting the cell as text afterwards shows Excel’s rendering of the serial, not the characters from the file.

catalog_code,ship_window,ratio_label,note
MARCH1,03/04/2026,1-2,letter-number code
SEPT2,2026-03-04,3/4,iso-looking window
OCT4,12-3,5/6,range not a date

These are invented catalog rows, not a gene list and not a shipment you can order. They are shaped like values that spreadsheets rewrite: MARCH1, a day-month-or-month-day string, an ISO-looking day, a ratio 3/4, and a range 12-3. The note is ordinary text so you can see that the risky columns sit beside a column that should never become a date.

What TableMender stores instead

Load the sample in CSV to Excel with Comma and the header on. The preview has three data records and four columns. MARCH1 stays six characters. 03/04/2026 stays ten characters with two slashes. 1-2 stays three characters. The workbook download, with every column left on Text, writes those strings as inline text. It does not create an Excel date type, a date format, or a formula. No calendar is consulted, so the tool cannot “pick” March versus April.

That is the point of the default. A text cell can look less convenient because SUM will not add it, and Excel may show a green hint that a number is stored as text. For a ship window and a catalog code, the hint is acceptable. The alternative is a value you can no longer audit.

If you open Excel column types and set the ship-window column to Number, download is blocked. The first window, 03/04/2026, matches the leading-zero guard because it begins with 03. The message talks about leading zeros, not about dates. The tool has no date type to name. The other windows fail the plain-decimal test because of hyphens. The ratio labels fail because of the slash or the hyphen. The catalog codes fail because they contain letters. The note fails if you mark that column as a number too. Zero numeric cells from this sample are accepted when any of those columns is numeric. Put the columns back on Text and the workbook downloads.

A sequence you can repeat

1. Keep the CSV. Do not start from a workbook that Excel has already opened and saved. The conversion you are trying to avoid may already have happened.
2. Open the converter and load date-looking-text.csv. Select Comma. Leave First record is a header on. Preview, and read the ship window and the ratio from the grid, not from memory.
3. Leave every Excel column on Text. Download the xlsx. Reopen it and compare MARCH1, 03/04/2026, 1-2, SEPT2, 2026-03-04, 3/4, OCT4, 12-3 and 5/6 with the CSV.
4. As a negative test, set only the ship-window column to Number and try to download. The block should name a source record and a column. Reset types. The source text is unchanged; reset does not rebuild lost characters because none were lost.
5. If you also export CSV from this tool, remember CSV has no column types. Excel may convert the new CSV on the way back in. The xlsx text cells are the handoff that avoids that parse. The BOM and formula-protection checkboxes apply to CSV output, not to the typed xlsx cells.

Build a text workbook →

Microsoft’s own workaround, when you must import in Excel, is to set the column to Text before the values land, or to use the text/CSV import path and assign types from the preview. An apostrophe typed in front of a value also forces text in Excel’s grid; the apostrophe is not part of the value Excel calculates with, but it is an extra character if a different program keeps it. TableMender does not add that apostrophe unless you turn on CSV formula protection, and these sample fields do not match the formula-like pattern. You do not need the apostrophe for the xlsx text cells.

Common errors compared

Edge cases

An ISO-looking value such as 2026-03-04 is still just text here. Some systems treat that shape as a date and others leave it. The sample does not include a time, a time zone, or a daylight-saving gap. TableMender will not normalize 2026-3-4 to two-digit months. If those strings differ, they are different fields.

5/6 is a ratio label in the sample, not five divided by six. Excel can turn a fraction into a fraction number type or into a date depending on how it is entered. The text workbook keeps the slash. If you later need the quotient, compute it in a new column from values you trust. Do not overload the label.

A genuine empty window should stay empty. An empty numeric cell is kept blank when the column really is numeric. Do not write 0 or 1900-01-01 as a substitute for missing. Excel’s date system has historical quirks around serial zero that this tool never applies, because it never writes date serials.

Codes with spaces, MAR 1 or MAR-1, are not in the sample. Microsoft notes that disabling the letter-and-number conversion may still leave spaced or punctuated forms eligible for date treatment inside Excel. A text-typed xlsx cell avoids that path for the value it stores. A CSV reimport can put the value back on the path.

Two-digit years are not interpreted. 03/04/26 is not in the file. If your export uses two-digit years, keep them as text and do not let this page’s four-digit example persuade you that the century is known.

Very long notes are unrelated to dates, but a field over 32,767 characters is rejected. The sample is far under the 5 MiB and 20,000-record limits. A failure at those limits is size, not a calendar.

Where the other tools fit

CSV repair will also preview these rows and can export them as UTF-8 CSV. That confirms the delimiter and the characters. It does not apply Excel types. If the only problem is a date conversion inside Excel, a new CSV can fall into the same conversion on the next open. Use the xlsx text workbook when the receiver is Excel and the columns must stay literal.

CSV clean compares strings. 03/04/2026 and 3/4/2026 are not duplicates of each other. MARCH1 and MARCH01 are not the same key. Cleaning will not collapse them, and it should not. If a later system thinks they are the same date, that system is interpreting, and the interpretation belongs in a reviewed mapping, not in a whitespace trim.

Scientific notation and fifteen-digit rounding are adjacent but separate. A tracking identifier with no slashes is covered in the large-number guide. Do not mark a date column numeric in order to “stop” scientific notation. The sample never becomes a number in this tool.

From the tools and home page

The CSV to Excel workbench links here because its default Text columns are the practical answer for ship windows and catalog codes. The home page How-to strip surfaces this guide next to leading zeros and one-column CSV opens, because those three failures often arrive in the same export. If a long tracking ID becomes an exponent instead of a date, read Large CSV numbers and scientific notation after you finish this page.

When the CSV first opens as a single column, fix the separator with CSV check & repair before you convert. Date rewriting only happens on real fields. A delimiter mistake hides which field Excel would have converted.

Limits

TableMender does not offer a Date column type. It will not sort these windows chronologically, fill a calendar, or check that 2026-03-04 was a Wednesday. If your workbook needs real date arithmetic, build those date cells in Excel from a text column you still have, using a parse you can name (year, month, day) rather than a general-format guess.

The tool does not read an existing xlsx. If Excel already replaced the text, this site cannot recover the slash form from the serial. Regional order cannot be inferred after the fact. Keep the export that still contains the characters.

Excel versions differ. The automatic-conversion checkboxes Microsoft documents for Microsoft 365 are not a promise about an older perpetual release, Excel for the web, or another vendor’s spreadsheet. Test the actual receiver with the sample file before you trust it with a larger export. A green triangle, a left-aligned cell, or a changed formula bar are observations in that program, not results this tool returns.

← All guides