Prevent Excel from Automatically Converting Imported Values to Dates in WPS Spreadsheets
Question details
The user wants to understand why values such as 12-1-1 are converted to dates during import and whether automatic data-type detection can be disabled or avoided.
- Product
- Microsoft Excel / WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A user imports a CSV or text file containing product codes, part numbers, or other hyphenated values such as 12-1-1 into a spreadsheet and wants the values to remain unchanged.
- Observed behavior
- The spreadsheet automatically interprets the values as dates, and applying Text formatting after conversion does not restore the original text.
Identify the columns that may be treated as dates and check the delimiter used in the source CSV or text file before opening the import dialog.
Set affected columns to Text in the WPS Spreadsheets Text Import dialog
Use this method before loading data to prevent WPS Spreadsheets or Excel from converting values such as 12-1-1 into dates.
Spreadsheet apps apply automatic data-type detection during CSV import. Once a value is converted to a date, changing the cell format to Text only changes the display, not the underlying value. The WPS Spreadsheets import dialog lets you control the column data format before the data is written.
Launch WPS Spreadsheets, click the menu button in the top-left corner, choose Open, select the CSV or TXT file, and click Open.
In the Text Import dialog, select Delimited or Fixed width, choose the delimiter that matches your file, such as comma, tab, semicolon, or space, and click Next.
Select the column that contains values such as 12-1-1, choose the Text column data format, and repeat for any other columns that should not be date-converted.
Click Finish, choose where to place the imported data, and confirm that the values appear exactly as they do in the source file.
Reconstruct already-converted values with a formula in WPS Spreadsheets
Use this recovery method if the import has already happened and the original text pattern is consistent, such as YY-M-D.
Prevent Automatic Date Conversion When Importing CSV Data in WPS Spreadsheets
Use the built-in WPS Spreadsheets Text Import dialog to control column data types before loading CSV or text files. It helps keep values such as 12-1-1 exactly as text without waiting for Microsoft 365 Insider settings.
- 1. Open WPS Spreadsheets: Install and launch WPS Office, then open WPS Spreadsheets from the home screen or Start menu.
- 2. Open the CSV or TXT file: Click the menu button and choose Open, or use Ctrl+O, select your CSV or TXT file, and click Open.
- 3. Select file type and delimiter: In the Text Import dialog, choose Delimited or Fixed width and set the delimiter used in the source file.
- 4. Set sensitive columns to Text: Select each column containing hyphenated or slash-separated values and choose the Text column data format.
- 5. Complete the import: Click Finish and choose the target location in the sheet to import the data without date conversion.
Frequently Asked Questions
Why does Excel convert 12-1-1 to a date automatically?
Excel treats values that match a recognized date pattern as dates during import. Because 12-1-1 can be interpreted as year-month-day or month-day-year depending on regional settings, it is converted into a date serial number.
Can I simply format the converted cells as Text to restore 12-1-1?
No. After the value has been converted to a date, formatting the cell as Text changes only the display format. The original text has already been replaced by a date serial number, so you need to import again with the column set to Text or use a recovery formula.
How do I choose the Text format for a column in WPS Spreadsheets during import?
When the Text Import dialog opens, select the column in the preview, choose the Text column data format, and repeat for any other columns that should not be converted. Then click Finish.
Does Microsoft Excel have a setting to turn off automatic date detection?
Some Microsoft 365 Insider builds are introducing controls for automatic data-type detection, but availability depends on the installed version and update channel. WPS Spreadsheets can prevent the conversion during the import step by setting the column format to Text.
Can I use this method for delimited files other than CSV?
Yes. The WPS Spreadsheets Text Import dialog works with CSV and TXT files that use commas, tabs, semicolons, spaces, or fixed-width columns.
