Change to text | number  
 
It is often the case that we wish to convert numeric values into text, to then perform certain calculations using the same values which have been converted to text.
Or perhaps, we simply wish to hide the formulas.
This tool can do the job.
Let us see an example:
We have a selected range that we wish to convert into text.
We click on the tool to be able to perform the task.
 
 
If any of the cells has a formula, the tool will detect it and it will ask us if we wish to continue.
After we confirm the task, we will see the results:
 
 
To undo the changes we simply click on the Excel undo button.