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, or a formula tweak?

Thanks.

- jim

[swatsp0p]

Try formatting your cells as General. Does this help? You may have set 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

Jim

[swatsp0p]

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

Cheers!