How do I get rid of negative zeros in excel?
- 1 Answers
- 761 Views
- I also Faced
- E-Mail Answers
Answer / Mahendra Prasad
To remove negative zeros from a cell or range of cells in Excel, you can use the following method: Select the cells with negative zeros, then choose 'Format Cells', navigate to the 'Number' tab, and pick 'Custom'. In the 'Type' box, input '0';[0-9]*' (without quotes) and click OK. This custom format will display all positive numbers as they are, but suppress negative zeros.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the latest version of excel?
Is there a free program like excel?
How do you autofit cell size to contents?
What do you mean by lookup?
How do you add a semicolon to a list in excel?
How do I apply conditional formatting to multiple columns?
What is a conditional formula?
How do you put a negative sign in excel?
Where is autosum in excel?
What is excel macro?
How do I combine data from multiple tabs in excel?
How do you select multiple rows in excel to delete?
MS Excel Microsoft 
