How to convert number to text in Excel?


This content was proof-read by Grammarly. You can Try Grammary for FREE

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.

How to convert number to text in Excel?
Newsletter Signup

Subscribe to our weekly newsletter below and never miss the latest product or an exclusive offer.

Newsletter Signup

Subscribe to our weekly newsletter below and never miss the latest product or an exclusive offer.

%d bloggers like this: