Forum Discussion
Seena2468
Sep 06, 2021Copper Contributor
convert decimal numbers to % in excel using format cell option
Hi, I am trying to convert decimal numbers to % but it is not converting the desired way. For e.g. decimal number is 95.83 and when I convert this to % using format cell option, it displays as 9583%...
- Sep 06, 2021
I would not recommend just format it. Because 95.85%=0,9583 it means its a value way inferior of 95.85.
But you can use the custom format as 00.00"%"
Otherwise you must divide your number by 100 and format it as %
Juliano-Petrukio
Sep 06, 2021Bronze Contributor
I would not recommend just format it. Because 95.85%=0,9583 it means its a value way inferior of 95.85.
But you can use the custom format as 00.00"%"
Otherwise you must divide your number by 100 and format it as %
- Seena2468Sep 06, 2021Copper Contributorcustom format 00.00"%" works. Thanks a lot, Juliano.