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%...
  • Juliano-Petrukio's avatar
    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 %

Resources