Fix Missing Decimal Places and Negative Currency Values in Excel
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.
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.
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.
In Excel, drag across the cells or select the entire worksheet range that needs the currency format.
Right-click the selection and choose Format Cells, or open the Home tab and use the Number format options.
On the Number tab of the Format Cells dialog box, select Currency and choose the required currency symbol.
Set Decimal places to 2, click OK, and verify that the selected values now display two decimal places.
Enter a negative currency amount as a number
Use this method when a negative amount must be entered after the cells have been formatted as currency.
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. Select the currency range: Open the workbook in WPS Spreadsheet and select the cells that need corrected currency formatting.
- 2. Open the cell-format dialog: Right-click the selection and choose Format Cells, then open the Number category.
- 3. Set Currency and decimals: Choose Currency, select the required symbol, set Decimal places to 2, and click OK.
- 4. Enter negative amounts: Type a value such as -150.00, or enter =-150.00 when the value should be calculated as a formula.

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.




