Zero values shown as 0 not 0.0

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

Does anyone know how to show any value smaller than 0.01
or greater than -0.01 as a single zero, i.e. 0, not 0.0?

Or how to make, for example, 0.0000076500 become 0.0?

Geoff
 
Thanks, but I'd like to show all non-zero values with one
decimal point. If I format the cell it will treat all
values in the same way, whether zero or not.

Geoff
 
Hi
try using a custom cell format like
+0.00;-0.00;0.0

to distinguish betwen positive, negative and zero numbers
 
Click on the cell you want to change. then click on
format, then style, then on modify. When you get here you
should choose numbers from the category side and then
enter 0 for the decimal place. I tried it and it worked
for several of my numbers.

Hope this is what you need.
 
Back
Top