I cannot figure out how to display a negative number as zero. Is there an easy way to do this?
M mvance4 Aug 8, 2007 #1 I cannot figure out how to display a negative number as zero. Is there an easy way to do this?
D Dave Peterson Aug 8, 2007 #3 Use a custom format of: General;\0;0;@ Positive numbers;negative numbers;zeros;text The display will be 0, but the value will still be negative.
Use a custom format of: General;\0;0;@ Positive numbers;negative numbers;zeros;text The display will be 0, but the value will still be negative.
B bj Aug 8, 2007 #4 if you want it to calculate as zero =max(A1,0) otherwise the format methods are best
