Forum Discussion

Seena2468's avatar
Seena2468
Copper Contributor
Sep 06, 2021
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%...
excel
  • Juliano-Petrukio's avatar
    Juliano-Petrukio
    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 %

mathetes's avatar
mathetes
Silver Contributor
Sep 06, 2021

Seena2468 

 

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%

Resources