-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
if the value is negative it shows as zero
- Thread starter Kdosreis
- Start date
barry houdini
MrExcel MVP
- Joined
- Mar 23, 2005
- Messages
- 20,825
Does the cell have a formula? If so you can change the formula to
=MAX(0, your_formula)
where your_formula is your original formula. This will change the value - if you just want to display as zero, without changing the underlying value you could custom format something like
0;"0";0
=MAX(0, your_formula)
where your_formula is your original formula. This will change the value - if you just want to display as zero, without changing the underlying value you could custom format something like
0;"0";0
Upvote
0
