Forum Discussion
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 tried custom option too, but it doesn't work. Any help would be greatly appreciated.
Thanks!
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 %
5 Replies
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)
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.
