Convert Numbers into Words Using VbA

Written by kazamraza no comments

There is a function BAHTTEXT in Excel that convert number/amount into words, but this function is in Thai language. Excel doesn’t have a default function that displays numbers as English words in a worksheet, but you can add this capability by pasting the following SpellNumber function code into a VBA (Visual Basic for Applications) module. This function lets you convert dollar and cent amounts to words with a formula, so 22.50 would read as Twenty-Two Dollars and Fifty Cents. This can be very useful if you're using Excel as a template to print checks. Open excel and create new excel workbook and save it as Macro Enabled Workbook. To confirm Macro Enabled Workbook Its file extension will be .xlsm.

Read more Convert Numbers into Words Using VbA