Forum Discussion
convert decimal numbers to % in excel using format cell option
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 %
Somewhere along the line of getting to the number 95.83 you will need to divide it by 100, since that's what percent means, "per 100".
=95.83/100 or, if the number is in cell A10, =A10/100
and then the basic format cell as percentage will display it as 95.83%
mathetes Many thanks for the reply. I am pasting values as numbers from another sheet and wanted to auto pick the % formatting. I think in this case custom 00.00"%" works.
Let me just offer this word of advice as a warning: IF you end up--or, worse, somebody else ends up--doing some further mathematical operations with that "95.83%," be aware that Excel (despite having accepted your custom formatting to look like 95.83%) will still consider it to be 95 and 83/100dths, not .9583, and if that mathematical operation is buried in a bigger operation of some kind, it might not be detected until some unanticipated and undesirable results are produced.
That is why, for the sake of data integrity (i.e., data really being what it says it is), you'd be better off fixing the underlying data, rather than just fixing how it looks. (IMHO)