Drop decimals and zeros when not needed

[home70]

I'm trying to drop decimals and zeros when they're not needed. For instance, if I type 3 I'd like to show as 3 instead of 3.00, and if I type 3.5 I'd like it to show 3.5 instead of 3.50. I can't find how to do this but surely it can be done.
Thanks.

 

[boblarson]

I'm trying to drop decimals and zeros when they're not needed. For instance, if I type 3 I'd like to show as 3 instead of 3.00, and if I type 3.5 I'd like it to show 3.5 instead of 3.50. I can't find how to do this but surely it can be done.
Thanks.

I believe if you set your format to "0.##" you will get what you want.

 

[home70]

Thank you for your help!

 

[boblarson]

Happy to help.