Hide the Negative Sign in Excel Custom Number Format Text
Question details
Display a text label for negative numbers without showing a minus sign.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants a custom number format to show the word Balance for negative values while leaving other numbers in the General format.
- Observed behavior
- The reported format displays -Balance for negative values instead of Balance.
Select cells containing numeric values, not numbers stored as text. Check the existing custom format in Format Cells before changing it.
Set a Literal Text Format for Negative Values in Excel
Use the negative-number section of a custom format to display Balance without a minus sign.
Custom number format sections are separated by semicolons. In this format, the first section controls positive values, the second controls negative values, and the third controls zeros.
In Excel, select the cells containing the values you want to format.
Open Format Cells, choose the Number tab, and select Custom.
In the Type box, enter General;"Balance";General, then click OK.
Look at a negative value in the selected range. It should display Balance, while positive values and zeros use General formatting.

Display Negative Values as Text in WPS Spreadsheets
Apply a custom number format in WPS Spreadsheets to show Balance for negative values without changing the underlying numbers.
- 1. Open your workbook: Open WPS Spreadsheets and choose the workbook you want to edit.
- 2. Select the cells: Select the cells containing the numeric values to format.
- 3. Choose a custom format: Open Format Cells, select the Number tab, and choose Custom.
- 4. Apply the format: Enter General;"Balance";General in the format field and click OK.

Frequently Asked Questions
Why are there semicolons in the custom format?
Semicolons separate format sections. In General;"Balance";General, the sections apply to positive numbers, negative numbers, and zeros, respectively.
Can I use a different word instead of Balance?
Yes. In Format Cells > Number > Custom, replace Balance with your preferred label and keep the quotation marks, for example General;"Deficit";General.
Does the custom format change the actual negative number?
No. The cell still contains its original negative value, so formulas and calculations continue to use that value.
What happens to zero values with this format?
The third section, General, controls zeros, so they display using General formatting rather than the Balance label.




