Preserve 23.20 Text Values When Exporting Excel to CSV
Question details
Prevent text values such as 23.20 from being automatically interpreted and displayed as 23.2 after a CSV file is saved and reopened.

- Product
- Microsoft Excel CSV export and import
- Device & OS
- not provided
- Scenario
- The user exports worksheet data to a CSV file and needs a trailing zero to remain part of a text value.
- Observed behavior
- CSV files do not retain Excel cell formatting, and Excel can reopen 23.20 as a numeric value and display it as 23.2.
A CSV is plain text and does not store Excel number formats or column data types. First, open the CSV in a text editor, such as Notepad, to determine whether 23.20 is stored correctly in the file.
Import the CSV column as text in Excel
Use this method when the CSV already contains values such as 23.20 and you need Excel to retain every character when loading the file.
Opening a CSV by double-clicking lets Excel automatically detect data types. Importing it through the Data tab lets you designate the affected column as Text instead.
In Excel, open a blank workbook, select the Data tab, and choose From Text/CSV.
Browse to the CSV file, select it, and choose Import to open the preview and import settings.
In the import or transform options, select the column containing values such as 23.20 and set its data type to Text rather than a numeric or automatic type.
Choose Load after confirming the column type. Excel will keep 23.20 as text instead of displaying it as 23.2.

Verify the CSV content before changing the export
Use this check when you need to find out whether the trailing zero was removed from the CSV itself or only changed by Excel's automatic display.
Export values as text when creating the CSV
Use this approach when you control the source worksheet and the values must always be treated as identifiers or text rather than numbers.
Import CSV Values as Text with WPS Spreadsheets
WPS Spreadsheets lets you import CSV data while controlling how individual columns are interpreted. Select the column containing values such as 23.20 and load it as text to prevent automatic numeric conversion.
- 1. Open the CSV import command: In WPS Spreadsheets, create or open a workbook and use the Data tab to open the CSV or text import option.
- 2. Choose the CSV file: Select the CSV file that contains the values you want to preserve and continue to the import preview.
- 3. Mark the column as text: Select the relevant column, such as the Sprint column, and set its data format to Text.
- 4. Load and check the values: Complete the import and confirm that values such as 23.20 remain unchanged in the worksheet.

Frequently Asked Questions
Why does Excel show 23.20 as 23.2 after I reopen a CSV file?
Excel automatically interprets unquoted values such as 23.20 as numbers when a CSV is opened directly. Its General number display removes insignificant trailing zeros, even if the CSV text contains 23.20.
Does a CSV file save Excel number formatting?
No. CSV files store plain values separated by delimiters; they do not retain Excel number formats, formulas, column widths, or data-type settings.
How can I check whether 23.20 is actually present in my CSV?
Open the CSV with a plain-text editor such as Notepad and locate the relevant row. If the text editor shows 23.20, the CSV stored the value correctly and Excel is only reinterpreting it on open.
What is the best way to open a CSV without losing trailing zeros in Excel?
In a blank workbook, select Data > From Text/CSV, choose the file, and set the affected column's data type to Text before loading it.
Can I use an apostrophe to force 23.20 to be text?
Yes, for manually entered source values, typing an apostrophe before 23.20 tells Excel to treat the entry as text. Check the resulting CSV in a text editor because the apostrophe may be written as a literal character depending on the export workflow.




