display negative number as zero

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.
 
G

Guest

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
Help with positive and negative numbers 1
Custom Number Format for text 8
Excel VBA to match positive and negative transactions 3
display negative numbers as zero 3
Negative Numbers 8
Dividing - Negative Number by Zero 5
How can I display negative numbers as zeros? 3

Top