Swap % to number  
 
Whenever we apply the percentage format to a range, using the tool available in Excel, we notice that the number changes too.
This is to say, if we have a cell containing 3 as its value, and we apply the Excel percentage, we will notice that the number has become 300%.
Sometimes, this change can create visual confusion.
Our Swap Percentage to Number tool solves this problem.
We will use the following range as an example:
 
 
We will select a column and then proceed to press the corresponding button.
 
 
We can see that the numbers have not changed and that the calculations have not changed at all.
To undo the effect, we simply select the corresponding range again, and click on the same button again.