Others

How to Fix Wrong Currency Symbol or Decimal Separator in Microsoft Lists

Emma BrownEmma Brown Oct 29, 2026 870 views

Question details

The user needs to correct the currency symbol and decimal separator displaying incorrectly in Microsoft Lists after importing data from an Excel file.

Fixing the Wrong Currency Symbol or Decimal Separator in Microsoft Lists
Product
Microsoft Lists / Excel
Device & OS
not provided
Scenario
Importing Excel spreadsheet data containing currency values into Microsoft Lists.
Observed behavior
Imported currency values display the wrong currency symbol (e.g., Dollar instead of Euro) and incorrect decimal separators, even when the appropriate regional setting is applied.
Before you start

Ensure you have list owner or edit permissions in Microsoft Lists and verify that your original Excel file contains properly formatted numerical currency data without hidden text characters.

Solution 1Recommended

Configure Column Types and List Regional Settings

Ensure the Microsoft List is using the correct regional locale and that specific columns are explicitly configured to the Currency data type.

Microsoft Lists often relies on site-wide regional settings to dictate how numbers and dates are displayed. If a column is imported as a generic number or text, it will not enforce the proper currency symbol.

1
Update Regional Settings

Go to Microsoft Lists and open your target list. Click the gear icon in the top right corner and select 'List settings'. Under 'General settings', click 'Regional settings' and ensure the 'Locale' is set to your target region (e.g., Dutch (Netherlands)).

2
Edit Column Settings

Return to the main list view. Click the column header for the incorrectly formatted currency and select 'Column settings', then click 'Edit'.

3
Set Column to Currency

Change the column type from 'Number' or 'Single line of text' to 'Currency'. Under 'More options', specify the exact currency format (e.g., € Euro) and click 'Save'.

Configure Column Types and List Regional Settings
Settings Applied: Updating the column explicitly to Currency overrides generic formatting and forces the list to display the chosen symbol.
Free Microsoft Office alternative

Format Your Spreadsheet Data Flawlessly with WPS Office

While cloud platforms like Microsoft Lists can struggle with imported data formats, you can easily clean, format, and prepare your spreadsheet data using WPS Office. It provides a lightweight, highly compatible, and free alternative to Microsoft Office.

  1. 1. Open your data file: Launch WPS Spreadsheet and open the document containing your financial data.
  2. 2. Select the data range: Highlight the cells or columns containing the numbers you wish to format.
  3. 3. Apply currency formatting: Right-click and select 'Format Cells'. Choose 'Currency', pick your preferred symbol and decimal settings, and click 'OK'.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv) to ensure seamless data migration.Easily configure regional currency symbols and decimal separators before exporting data.Lightweight software that runs smoothly on Windows, Mac, and Linux.Familiar user interface makes it incredibly easy to learn and use.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Lists change my Euro symbol to a Dollar sign?

This usually happens when the imported column is mapped as a generic Number or Text instead of Currency, causing the list to fall back on default site regional settings (often US English). Explicitly setting the column type to 'Currency' and choosing the Euro format in Column Settings resolves this.

Do SharePoint regional settings affect Microsoft Lists?

Yes. Microsoft Lists are built on the SharePoint platform. The regional settings of the underlying SharePoint site dictate the default decimal separators, currency default symbols, and date formats for the list.

How do I fix the decimal separator showing as a comma instead of a period?

Decimal separators are controlled by the list's 'Regional settings'. To change this, go to List settings > Regional settings, and change the 'Locale' to a region that uses your preferred decimal format (e.g., United States for periods, or Netherlands for commas).