Click the Save button disk icon and then go back to your spreadsheet window. VALUEG2 Replace G2 above with the cell that has the number you want to convert. Save this code and go back the worksheet in a blank cell enter this formula SpellNumberToEnglishA2 A2 is the cell you want to convert the number to an English currency word and then drag the fill handle down to the cells that you want to apply this formula all the numbers have been spelt out into English currency words see screenshot.
It truncates if you have a value having more than two decimal places.
It works for a value having two decimal places. Unlike a painful process of pasting macros to do this job every time you open a new Excel workbook once this add-in is installed on the computer user will never have to worry about the tedious coding job. VALUEG2 Replace G2 above with the cell that has the number you want to convert. This formula can convert numbers.