Best Way to Remove trailing '.0' for Whole Percentage Numbers

[Statto]

I am wondering what is the best way to display a percentage so that if it is a whole number, it shows as 5% instead of 5.0%, for example. Any other percentage that isn't a whole should still display like it usually would. Eg. 6.2% as 6.2%, 9.9% as 9.9% etc. I'm not interested in using any custom cell formatting to achieve this — I want to do it via a formula that involves the TEXT function.

Please see my example attached.

[sanram]

You can use this :

Please Login or Register  to view this content.

[AlKey]

Try this

Please Login or Register  to view this content.

v	A	B
1	5.0%	5%
2	6.2%	6.2%
3	9.9%	9.9%
4	55.0%	55%
5	10.0%	10%
6	100.0%	100%
7	13.8%	13.8%

[Statto]

Both of those methods work equally well. Thanks guys!

[sanram]

You are welcome and thanks for the rep.