Convert Numbers to Words in Excel The first method for converting a number to its written equivalent is to use direct entry. The apostrophe will not be displayed in the cell but it will tell Excel to treat the contents of the cell as text. Select the list of numbers you want to convert and then click Kutools Content Numbers to Words see screenshot.
Select the column where you want to convert numbers to string in Excel.
Number to Text Using Excel Functions Convert a Number to Text By Adding an Apostrophe The quickest way to convert an Excel number to text is to insert an apostrophe in front of the number see rightabove. Select the numbers that you want to convert to text. You can now use the EnglishNumber function to convert a number to words. Select the first cell in the empty column you formatted right-click the cell and select Paste Values.