Show Decimals only if needed

[schneitodd]

I have a Summary sheet that adds up numbers from several sheets. In the summary table, I would like to only show decimals if they are needed. For example, if the sum is 4, show as "4" not "4.0", but if the sum is 3.1, show as "3.1".
How can I do this?

 

[Richard Schollar]

You can kinda do this via number formatting, but I can't seem to get a way of losing the decimal point if there are no fractional values.

Anyway, format in the custom box is:

0.#;-0.#

Best regards

Richard

 

[xapie128]

Simply set the cell format back to General should do the trick.

 

[Richard Schollar]

Simply set the cell format back to General should do the trick.

So simple!

I would love to know if it is possible to get rid of the decimal separator (.) though thru a custom format.

Richard

 

[mortgageman]

I found this post educational (I never knew what the heck "general" really did) and interesting. I know that this will do exactly what the OP wanted, but it seems funny to me - here is why:

Let's say the a4's cell format is general, and the contents are =A2+A3
Let's also say that a2 has 3.1 and a3 has 7.9. A4 will then show 11, even though any math teacher would say that the answer (because of "significant digits") is 11.0

Gene, "The Mortgage Man", Klein