Formatting Issues

Stop Excel from Converting APR-2644 to a Date

Phi Hung VoPhi Hung Vo Nov 18, 2026 868 views

Question details

Preserve values such as APR-2644 as text instead of allowing Excel to interpret them as dates.

Stop Excel from Converting APR-2644 to a Date
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.
Before you start

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.

Solution 1Recommended

Format Excel cells as Text before entering values

Use this method when you can prepare the destination cells before typing the identifiers.

1
Select the destination cells

In Excel, select the cells or column where you will enter values such as APR-2644.

2
Apply the Text format

On the Home tab, open the Number Format drop-down and select Text.

3
Enter the values

Type APR-2644 into a formatted cell and press Enter. Repeat for the remaining identifiers.

Format Excel cells as Text before entering values
Apply the format first: Formatting a cell as Text after Excel has converted an entry to a date does not necessarily recover the original value. Re-enter the value from the source if needed.
WPS Spreadsheets

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. 1. Open your spreadsheet: Launch WPS Spreadsheets and open the workbook where you want to enter the identifiers.
  2. 2. Select and format the cells: Select the destination cells, then use the Home tab's number format menu to choose Text.
  3. 3. Enter the identifiers: Type APR-2644 into a formatted cell and press Enter, then check that it appears unchanged.
Preserve date-like identifiers as text during entryOpen and edit Microsoft Excel XLS and XLSX filesUse familiar spreadsheet formatting controlsWork with a free, easy-to-use office suite
microsoft office alternative - wps office

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.