Forum Discussion
HE_Blandswift
Sep 11, 2023Copper Contributor
Excel Novice
How can I hide a negative number (or show it as 0)?
NikolinoDE
Sep 11, 2023Gold Contributor
In Excel, you can hide negative numbers or display them as 0 by using a custom number format. Here is how you can do it:
- Select the cell or range of cells that contains the numbers you want to format.
- Right-click on the selected cell(s) and choose "Format Cells" from the context menu.
- In the Format Cells dialog box, go to the "Number" tab.
- In the "Category" list on the left, select "Custom."
- In the "Type" input box, you can specify a custom number format. To hide negative numbers or display them as 0, you can use the following format:
For hiding negative numbers: 0;0;0;
For displaying negative numbers as 0: 0;0;0;0
- Click the "OK" button to apply the custom number format.
Now, the selected cells will display negative numbers as either 0 (if you chose the second format) or as completely blank (if you chose the first format). Positive numbers will be displayed as is.
Keep in mind that this formatting change is only cosmetic. The actual values in the cells remain unchanged. If you need the modified values for calculations, you may need to perform additional operations or use formulas to work with them as needed. The text and steps were created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark them as helpful and like it!
This will help all forum participants.