Essentially the function will convert a numeric value into a text string.

What is the formula to convert number to text in excel 2007. Press CTRL C to copy the cell. To convert numbers into text values you can use the TEXT function. TEXT B50 The result is the number 1021 formatted as text 1021.

Save and close this code and go back the worksheet in a blank cell enter this formula NumberstoWordsA2 A2 is the cell you want to convert the number to an English word see screenshot. If you are looking for the number to text conversion which means you want Excel to see your number as text its a bit different. This method does not work in some scenarios.

Select your range with numbers. FormattedSee more How to convert number to text in Excel. To use this function select the cell where you want the converted number to go and type.

Select the range with the numeric values you want to format as text. In the example shown the formula in C5 is. Select the cells that have numbers stored as text.

On the Home tab click Paste Paste Special. Enter the formula TEXT C20 to the cell D2. TEXT value format_text.

Then press Enter key and select cell D1 drag the fill handle to the range which you want to apply this formula. To convert numbers into text values you can use the TEXT function. The VALUE function will try to coerce a number stored as text to a.