How to Fix Wrong Currency Symbol or Decimal Separator in Microsoft Lists
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.

- 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.
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.
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.
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)).
Return to the main list view. Click the column header for the incorrectly formatted currency and select 'Column settings', then click 'Edit'.
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'.

Clean and Convert Excel Data Before Importing
Format the data properly in Excel to prevent Microsoft Lists from misinterpreting currency values as text strings during the import process.
Test the Import with a New Microsoft List
Create a new list to determine if the formatting issue is specific to a corrupted or legacy list configuration.
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. Open your data file: Launch WPS Spreadsheet and open the document containing your financial data.
- 2. Select the data range: Highlight the cells or columns containing the numbers you wish to format.
- 3. Apply currency formatting: Right-click and select 'Format Cells'. Choose 'Currency', pick your preferred symbol and decimal settings, and click 'OK'.

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).




