Formatting Issues

Excel: Remove Unwanted Decimal Formatting from Currency Values

Nimra MalikNimra Malik Nov 12, 2026 869 views

Question details

The user needs to remove an unwanted decimal and separator display from currency values in Excel.

Excel: Remove Unwanted Decimal Formatting from Currency Values
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.
Before you start

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.

Solution 1Recommended

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.

1
Open regional settings

In Windows, open Settings, select Time & language, choose Language & region, and review the Regional format settings and related date, time, and number formats.

2
Review number separators

Open the system’s regional format customization area and verify the Decimal symbol, Digit grouping symbol, Digit grouping, and List separator.

3
Check Excel separators

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.

4
Reopen or recalculate the workbook

Close and reopen the workbook, then check the affected currency cells to confirm that the separators now match the intended regional format.

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. 1. Open the workbook: Launch WPS Spreadsheet and open the affected Excel workbook.
  2. 2. Select the currency range: Highlight the cells that show the unwanted decimal or separator formatting.
  3. 3. Open Format Cells: Right-click the selection and choose Format Cells, or use the Home tab’s Number Format controls.
  4. 4. Set currency or accounting formatting: Choose Currency or Accounting, select the correct currency symbol, and specify the number of decimal places.
  5. 5. Verify the result: Click OK and confirm that the values display the intended separators and decimal precision.
Quickly correct unwanted decimal places and currency separatorsUse familiar Format Cells controls to customize symbols and precisionOpen and edit Microsoft Excel XLS and XLSX files with strong format compatibilityWork with a lightweight spreadsheet editor for everyday formatting tasks
microsoft office alternative - wps office

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.