Formatting Issues

How to Fix Excel Displaying Incorrect Decimal Places in Currency Format

Chanuka Geekiyanage Oct 19, 2026 868 views

Question details

The user needs to correct the number of decimal places displayed when applying Currency or Accounting formats to cells in Excel.

How to Fix Excel Displaying Incorrect Decimal Places in Currency Format

Product: Microsoft Excel
Device & OS: Windows
Scenario: Applying standard monetary formats to numeric values in a spreadsheet.
Observed behavior: Excel displays an abnormal number of decimal places and separators, such as showing 71050.0.0 instead of the standard 71050.00.

Before you start

Ensure you save your work and completely close Microsoft Excel before making changes to your system's regional or language settings.

Solution 1Recommended

Change Windows Regional Format to English (United States)

Adjusting the default Windows regional format often resolves conflicts that cause Excel to display multiple decimal points.

Excel relies heavily on your computer's system settings to determine how numbers, currencies, and dates should be formatted. If your regional language settings are mismatched or corrupted, it can result in formatting errors like extra decimal separators.

Close Excel

Make sure Microsoft Excel is completely closed, as system changes will not take effect if the application is currently running.

Open Windows Settings

Click the Start menu and open 'Settings', then navigate to 'Time & Language' and select 'Region'.

Change Regional Format

Under the 'Regional format' dropdown, change the setting to 'English (United States)'.

Test the Format in Excel

Reopen Excel. Enter a test number like 71050 into two separate cells. Apply the Currency format to the first cell and the Accounting format to the second cell to verify they display correctly as 71050.00.

Change Windows Regional Format to English (United States)

Verification Step: Both cells should now properly display the value with exactly two decimal places and a single decimal point.

Solution 2

Manually Reset System Separator Settings

If changing the default language does not work, you can manually override and fix the decimal and grouping symbols in the Control Panel.

Seamless Spreadsheet Formatting

Easily Control Decimal Places with WPS Spreadsheet

WPS Office provides an intuitive and reliable interface for managing number formats. You can effortlessly format currency and accounting data, ensuring your decimal places display exactly as intended without system setting conflicts.

1. Select Your Data: Open your spreadsheet in WPS Office and highlight the cells containing the numbers you want to format.
2. Open Format Cells Menu: Right-click the selected cells and choose 'Format Cells' from the dropdown menu, or press Ctrl+1.
3. Choose Currency or Accounting: Navigate to the 'Number' tab and click on either 'Currency' or 'Accounting' from the Category list.
4. Adjust Decimal Places: Set the 'Decimal places' counter to 2 (or your required number) and click 'OK' to instantly apply the clean formatting.

Easily customize decimal places for any numeric formatHighly compatible with Microsoft Excel (.xlsx) filesIndependent formatting controls that avoid system regional bugsLightweight, fast, and completely free to use

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show multiple decimal points like 71050.0.0?

This glitch occurs when there is a mismatch or corruption in your Windows regional language settings. Excel relies on Windows for default number formats, so a conflict in system separators translates into incorrect formatting in your spreadsheet.

What is the difference between Currency and Accounting formats in Excel?

While both are used for monetary values, the Accounting format aligns currency symbols and decimal points perfectly in columns for easier reading. The Currency format simply places the currency symbol directly next to the value.

Can I change decimal separators in Excel without altering Windows settings?

Yes. You can override system settings directly within Excel. Go to File > Options > Advanced. Under the 'Editing options' section, uncheck 'Use system separators' and manually type a period (.) in the 'Decimal separator' box.

Will changing the regional format affect my other applications?

Yes, modifying the regional format in Windows Settings changes how dates, times, and numbers are displayed across your entire operating system and in most installed applications, not just Microsoft Excel.

Document & File Issues