format a cell to read zero for any negative value

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

Guest

I would like some advise to show a zero value in a cell when ever the sum
value of this cell is a negative value
 
Use a Custom Format, such as

General;\0

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Hi Tony,
You have two completely different responses, one will change
the value, the other will not change the value but will change
the display. Both replies are correct interpretations based on
how you asked the question.
 
Great this one worked perfectly for me! I tried 2 other suggestions but they
didn't work at all.
 

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

Question about conditional formatting of zeros in Excel 0
Custom Number Format for text 8
Dividing - Negative Number by Zero 5
Replace the minus value 3
Format Cells - Accounting - Discrepancy? 3
Reallocate array cells value from positive to negative 0
Returning Zero 10
How do I eliminate negative values in a spreadsheet ? 2

Back
Top