hi

Right click on the cell that has the % value of number and then on the
general tab select general option then the value in % is converted to
equivalent decimal value.

haope this helps you