Data Import & Export

How to Convert Decimal Text from CSV to Numbers in Excel 365

Aamir Naveed AkramAamir Naveed Akram Nov 3, 2026 869 views

Question details

Decimal values imported from a CSV file are treated as text instead of numerical values in Excel 365.

How to Convert Decimal Text from CSV Files to Numbers in Excel 365
Product
Excel 365
Device & OS
Windows
Scenario
Importing a CSV dataset into Excel where the source file uses a different decimal separator than the computer's regional settings.
Observed behavior
The imported decimal figures behave like text strings, preventing mathematical calculations, sorting, and data analysis.
Before you start

Open your CSV file in a plain text editor like Notepad to confirm exactly which character (such as a period or a comma) is used as the decimal separator.

Solution 1Recommended

Temporarily Change the Decimal Separator in Excel Options

Override your system's default decimal separator directly within Excel to match the CSV file format before importing.

This is the most direct method as it only affects Microsoft Excel and won't change how other Windows applications display numbers.

1
Open Excel Options

Launch Excel 365, click on 'File' in the top-left corner, and select 'Options' at the bottom of the menu.

2
Access Advanced Settings

In the Excel Options dialog box, click on the 'Advanced' tab in the left pane.

3
Disable System Separators

Scroll down to the 'Editing options' section. Uncheck the box that says 'Use system separators'.

4
Set the Custom Decimal Separator

In the 'Decimal separator' field, enter the character used in your CSV file (for example, a period). Click 'OK' to apply the changes.

5
Import and Revert

Open or import your CSV file so the numbers are recognized correctly. Afterward, you can return to the Advanced options and re-check 'Use system separators' to restore your original settings.

Temporarily Change the Decimal Separator in Excel Options
Quick Conversion: Once imported correctly, your previously text-formatted decimals will behave as standard numbers ready for calculation.

Import CSV Files with Custom Separators Easily in WPS Office

WPS Spreadsheet features an advanced Text Import Wizard that allows you to specify decimal separators on the fly without altering your global software or system settings. This makes handling international CSV files effortless.

  1. 1. Open the Data Tab: Launch WPS Spreadsheet, navigate to the 'Data' tab on the top ribbon, and click 'Import Data'.
  2. 2. Select Your CSV File: Browse your computer for the CSV file and open it. The Text Import Wizard will automatically launch.
  3. 3. Configure Delimiters: Choose 'Delimited' and select the character that separates your columns (typically a comma or semicolon).
  4. 4. Set Custom Decimal Separators: In step 3 of the wizard, click the 'Advanced' button. Here, you can explicitly define the decimal and thousands separators used in your text file. Click 'OK' and 'Finish'.
Built-in Advanced Text Import Wizard to specify decimal and thousand separators directlyHighly compatible with Microsoft Excel formats including .xlsx, .xls, and .csvLightweight architecture handles large data imports fast and without crashingFree to download with an intuitive, familiar user interface
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel convert my CSV decimals into text or dates?

Excel relies on your computer's regional settings to interpret data. If your CSV file uses a period for decimals but your Windows region is set to use a comma (common in European countries), Excel fails to recognize the number format and defaults to treating it as text or a date.

Can I use the Text to Columns feature to fix the decimal text?

Yes. Select the column containing the text decimals, go to the 'Data' tab, and click 'Text to Columns'. Choose 'Delimited', click Next twice to reach step 3, then click the 'Advanced...' button. Specify the correct decimal separator used in the text, then click Finish.

Will changing my system separators affect other Office applications?

If you change the setting via the Windows Control Panel, it will affect all programs on your computer. If you only uncheck 'Use system separators' within Excel Options, the change will strictly apply to Excel.