I want 0.05 to show as “5%”
I want 0.055 to show as “5.5%”
I would expect the custom formatting of “#.#%” to work, but I get “5.%” and “5.5%”.
It seems the decimal placeholder is treating the percent symbol as a valid digit, and thus displaying a period when it shouldn’t
With Russian locale, which uses , as decimal separator, #,#% gives expected result (5% and 5,5% for 0.05 and 0.055 resp.); with English (USA) locale, #.#% works (5% and 5.5%). I am testing with Version: 5.4.1.2 (x64)
Build ID: ea7cb86e6eeb2bf3a5af73a8f7777ac570321527
CPU threads: 4; OS: Windows 6.19; UI render: default;
Locale: ru-RU (ru_RU); Calc: group
You don’t give your system and version info.
Excellent, there’s hope! I’m on 4.4, and I have no excuse or idea why updating wasn’t the first thing I tried
Yes, I reproduce your problem with Version: 4.4.0.3
Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7
Locale: ru_RU
4.4 is way outdated…
Unfortunately, it still puts a decimal right before the percent sign: “5.%”