Percent formatting

[Tim C]

I want these numbers:

0.1
0.08
0.081
0.0815
0.08125

to display like this:

10%
8%
8.1%
8.15%
8.13%

The custom format 0.##% does not work, because it shows 10.% and 8.% instead
of 10% and 8%

Any ideas? (If the question looks familiar, that's because I ask it about
once a year, hoping something new can help me.)

Thanks,
Tim C

 

[Ola]

Hi,

Here is one solution:
=TEXT(A1,"0"&CHOOSE(LEN(B32),"","","","",".0",".00",".00")&"%")

Ola