display negative number as zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing a inward/outward stocktake and sometimes it returns a negative
number. I want to be able to display this negative number as zero but display
any positive numbers as they are.
 
If you want to display 0, but retain the negative value in the cell, you
could try a custom number format:

#;"0";0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to reconcile a column 1
Question about conditional formatting of zeros in Excel 0
Displaying negatives with (brackets) 3
display negative numbers as zero 3
How can I display negative numbers as zeros? 3
Custom Number Format for text 8
Dividing - Negative Number by Zero 5
Help with positive and negative numbers 1

Back
Top