Forum Discussion
Solved
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%...
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 %
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 %
custom format 00.00"%" works. Thanks a lot, Juliano.