In Microsoft Excel 2016 , there are times when you don’t want the numbers present in the cell to be participating in the calculation. This means , you can either update the formula to not include the cell value or else change the number to text.
How to convert number to text in Microsoft Excel 2016?
You can use the TEXT function in Excel to convert a number to text in Microsoft Excel 2016.
To convert the number to text without using the formatting , use the formula =TEXT(B1,"0") in the cell C1 assuming the cell B1 contains the actual number.