Stop Excel from Converting APR-2644 to a Date
Question details
Preserve values such as APR-2644 as text instead of allowing Excel to interpret them as dates.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering or importing identifiers that resemble dates into a worksheet.
- Observed behavior
- Excel may interpret a value such as APR-2644 as a date instead of preserving the original text.
Identify the cells or source column that must remain text, and apply the text setting before entering or importing the values. If Excel has already converted a value, changing its format to Text may not restore the original entry.
Format Excel cells as Text before entering values
Use this method when you can prepare the destination cells before typing the identifiers.
In Excel, select the cells or column where you will enter values such as APR-2644.
On the Home tab, open the Number Format drop-down and select Text.
Type APR-2644 into a formatted cell and press Enter. Repeat for the remaining identifiers.

Prefix an individual value with an apostrophe
Use an apostrophe when entering a few values without changing the format of the entire column.
Import the source column as text
Use Excel's import settings when bringing in a CSV or other text file containing date-like identifiers.
Keep date-like identifiers as text in WPS Spreadsheets
In WPS Spreadsheets, format destination cells as Text before entering identifiers such as APR-2644, so they remain text rather than being interpreted as dates.
- 1. Open your spreadsheet: Launch WPS Spreadsheets and open the workbook where you want to enter the identifiers.
- 2. Select and format the cells: Select the destination cells, then use the Home tab's number format menu to choose Text.
- 3. Enter the identifiers: Type APR-2644 into a formatted cell and press Enter, then check that it appears unchanged.

Frequently Asked Questions
Why does Excel turn APR-2644 into a date?
The value resembles a month-and-year date pattern, so Excel may interpret it as a date during entry or import. Format the destination cells as Text before entering it.
Will changing a converted date to Text restore APR-2644?
Not necessarily. Once Excel has converted the entry, its original text may be lost. Format the cell as Text and re-enter the value from the source.
Does the apostrophe appear in the worksheet cell?
No. When you type 'APR-2644 into a cell, Excel displays APR-2644 and treats the entry as text.
How can I prevent date conversion when opening a CSV?
Use Data > From Text/CSV instead of opening the file directly. Select Transform Data and set the identifier column to Text before loading it.
Should I use DATEVALUE to preserve an identifier as text?
No. DATEVALUE converts recognized date text to a date serial number. Use Text formatting, a leading apostrophe, or a text column type during import instead.




