Custom Percentage Format

[mcget]

Hi All,

Wonder if anyone can help me, im trying to set a custom percentage format that can show the following;

If a result is 99.00% i want it to only show 99%
If a result is 99.50% i want it to only show 99.5%
If a result is 99.63% i want it to show 99.63%

I dont know if there is anything that can be done in the style of 00%;00.0%;00.00%.

Im creating a performance dashboard and this would help the results look a lot less messy, without all the .00%'s

Any help would be much appreciated!

Cheers

Paul

 

[morleyuk]

The closest I can get is custom format 0.##% but it does leave the decimal point