Formatting Issues

Hide the Negative Sign in Excel Custom Number Format Text

Natalie TaylorNatalie Taylor Nov 18, 2026 870 views

Question details

Display a text label for negative numbers without showing a minus sign.

Hide the Negative Sign in Excel Custom Number Format Text
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.
Before you start

Select cells containing numeric values, not numbers stored as text. Check the existing custom format in Format Cells before changing it.

Solution 1Recommended

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.

1
Select the cells

In Excel, select the cells containing the values you want to format.

2
Open custom formats

Open Format Cells, choose the Number tab, and select Custom.

3
Enter the format

In the Type box, enter General;"Balance";General, then click OK.

4
Check the result

Look at a negative value in the selected range. It should display Balance, while positive values and zeros use General formatting.

Set a Literal Text Format for Negative Values in Excel
The value stays negative: The format changes only the display. Excel retains the original numeric value for calculations.
WPS Spreadsheets

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. 1. Open your workbook: Open WPS Spreadsheets and choose the workbook you want to edit.
  2. 2. Select the cells: Select the cells containing the numeric values to format.
  3. 3. Choose a custom format: Open Format Cells, select the Number tab, and choose Custom.
  4. 4. Apply the format: Enter General;"Balance";General in the format field and click OK.
Display a text label instead of a negative signKeep numeric values available for calculationsWork with Microsoft Excel XLS and XLSX files
microsoft office alternative - wps office

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.