Zero values shown as 0 not 0.0

[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

 

[Frank Kabel]

Hi
format the cell: goto 'Format - Cells'

 

[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

 

[Frank Kabel]

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

to distinguish betwen positive, negative and zero numbers

 

[TJG]

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.