For example, 65% is read as “Sixty-five percent” and is equivalent to 65/100 or 0.65.
Accordingly, the values in column C aredecimal values, with thePercentage number formatapplied.
Get original number from percent change
To calculate the original number based on current value and known percentage change, you can use a simple formula that divides the current value by the percent + 1. In the example shown, the formula in cell E5 is: =D5/(C5+1) The results in column E are decimal values with the percentage number format applied.
