Calculation Issues

Fix Missing Decimal Places and Negative Currency Values in Excel

Bushra ParveenBushra Parveen Nov 12, 2026 869 views

Question details

The user needs to restore decimal places and enter negative currency values correctly in a recovered or reformatted workbook.

Product
Microsoft Excel
Device & OS
not provided
Scenario
A workbook's number formatting changed after recovery or reformatting, and currency amounts need consistent decimal display.
Observed behavior
Affected cells do not show the expected decimal places, and negative currency amounts are difficult to enter or display correctly.
Before you start

Select the affected cells or the full range that should use the same currency format. Confirm the intended currency symbol and decimal precision before changing the number format.

Solution 1Recommended

Apply Currency formatting with two decimal places in Excel

Use this solution when affected cells no longer show the required decimal places or currency display.

Formatting the cells as Currency controls how numeric values are displayed without requiring the currency symbol to be typed into each entry. Applying the format to the complete range keeps the workbook consistent.

1
Select the affected cells

In Excel, drag across the cells or select the entire worksheet range that needs the currency format.

2
Open Format Cells

Right-click the selection and choose Format Cells, or open the Home tab and use the Number format options.

3
Choose Currency

On the Number tab of the Format Cells dialog box, select Currency and choose the required currency symbol.

4
Set two decimal places

Set Decimal places to 2, click OK, and verify that the selected values now display two decimal places.

Format currency decimals and negative values in WPS Spreadsheet

WPS Spreadsheet lets you select a range, open Format Cells, choose Currency, set two decimal places, and enter negative amounts as standard numeric values. It provides a familiar spreadsheet workflow for restoring consistent financial formatting.

  1. 1. Select the currency range: Open the workbook in WPS Spreadsheet and select the cells that need corrected currency formatting.
  2. 2. Open the cell-format dialog: Right-click the selection and choose Format Cells, then open the Number category.
  3. 3. Set Currency and decimals: Choose Currency, select the required symbol, set Decimal places to 2, and click OK.
  4. 4. Enter negative amounts: Type a value such as -150.00, or enter =-150.00 when the value should be calculated as a formula.
Restore two-decimal currency formatting across selected cellsEnter negative amounts such as -150.00 without manually typing the currency symbolUse a familiar Format Cells workflow for recovered or reformatted spreadsheetsOpen, edit, and save Microsoft Excel XLSX files with compatible formatting
microsoft office alternative - wps office

Frequently Asked Questions

Why are my Excel currency values missing decimal places?

The affected cells may have been changed to General or another number format. Select the cells, open Format Cells, choose Currency, set Decimal places to 2, and click OK.

How should I type a negative currency amount in Excel?

Enter the numeric value with a minus sign, such as -150.00, after applying the Currency format. Excel will add the currency symbol and display style automatically.

Can I enter a negative currency value as a formula?

Yes. Type =-150.00 in the cell and press Enter. The cell's existing Currency format should display the calculated negative value correctly.

How can I format several currency cells at once?

Select the complete range before opening Format Cells. Choose Currency, set the symbol and two decimal places, then click OK to apply the settings to all selected cells.

Will WPS Spreadsheet preserve Excel currency formatting?

WPS Spreadsheet can open and save XLSX workbooks and supports common currency, decimal, and formula formatting. Check the saved file after conversion when advanced Excel-specific features are involved.