Excel: Remove Unwanted Decimal Formatting from Currency Values
Question details
The user needs to remove an unwanted decimal and separator display from currency values in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Currency values show an unexpected format such as “/.10,” and the user wants the correct currency or accounting display.
- Observed behavior
- Currency cells display an unwanted decimal or digit separator, potentially because of regional settings or an incorrect number format.
Identify one affected cell and compare its displayed value with the value shown in the formula bar. Check the computer’s decimal symbol, digit-grouping symbol, digit grouping, and list separator before changing the workbook format.
Check regional settings and Excel separator options
Use this solution when the same unexpected decimal or separator appears across multiple workbooks or many cells.
Excel can use the computer’s regional separators or custom separators configured in its advanced options. A mismatch between the decimal symbol and digit-grouping symbol can make currency values appear incorrectly.
In Windows, open Settings, select Time & language, choose Language & region, and review the Regional format settings and related date, time, and number formats.
Open the system’s regional format customization area and verify the Decimal symbol, Digit grouping symbol, Digit grouping, and List separator.
In Excel, select File > Options > Advanced, find the Editing options section, and review Use system separators. If needed, clear it and enter the correct Decimal separator and Thousands separator.
Close and reopen the workbook, then check the affected currency cells to confirm that the separators now match the intended regional format.
Apply the correct currency or accounting number format
Use this solution when only specific cells or ranges show the unwanted decimal formatting.
Format Currency Values Correctly in WPS Spreadsheet
WPS Spreadsheet lets you correct unwanted currency decimals and separators by reviewing the cell format and applying a suitable Currency or Accounting style from the Number Format controls.
- 1. Open the workbook: Launch WPS Spreadsheet and open the affected Excel workbook.
- 2. Select the currency range: Highlight the cells that show the unwanted decimal or separator formatting.
- 3. Open Format Cells: Right-click the selection and choose Format Cells, or use the Home tab’s Number Format controls.
- 4. Set currency or accounting formatting: Choose Currency or Accounting, select the correct currency symbol, and specify the number of decimal places.
- 5. Verify the result: Click OK and confirm that the values display the intended separators and decimal precision.

Frequently Asked Questions
Why does Excel show an unexpected decimal or separator in currency values?
The display may be affected by Windows regional settings, Excel’s Use system separators option, or a custom number format applied to the cells.
How do I change the decimal symbol used by Excel?
Go to File > Options > Advanced, find Editing options, clear Use system separators, and enter the required Decimal separator and Thousands separator.
How can I remove extra decimal places from currency cells?
Select the cells, open Format Cells with Ctrl+1, choose Currency or Accounting, and set Decimal places to the number you want, such as 0 or 2.
What is the difference between Currency and Accounting format?
Currency format places the currency symbol next to the value, while Accounting aligns currency symbols and decimal points consistently across a column.
Will changing the number format change the actual currency value?
Normally, no. Currency and Accounting formats change the appearance of the stored value; rounding may only affect what is displayed unless you use a separate rounding formula.




