display/not display numbers to right of decimal

[James C]

I have a formula in a cell producing results:
e.g. - 40.00
e.g. - 40.25

If the result is an integer, I want it displayed as "40", not "40.00".

Hence, I would like to display:
40
40.25

Is there an easy way to do this, either through formatting the cell, o
a formula tweak?

Thanks.

- ji

 

[swatsp0p]

Try formatting your cells as General. Does this help? You may have se
your format to Number, which, by default, places 2 decimals in <every
answer. You can alter the default 2 decimals anywhere from zero to 30
but this well impact every entry whether it is an integer or not

 

[James C]

Swatsp0p,

that did it
thanx very much

Ji

 

[swatsp0p]

I'm glad it worked for you. Thanks for the feedback, it is alway
appreciated.

Cheers