Spelling Numbers-Convert figures to Text through Lookups

For executives whom are performing billing using excel spreadsheets, there maybe times where there is a need to spell out the amounts billed in template in English words.

For such requirements, you may find the tool provided by Contextures over at his Convert Numbers to Words Article extremely useful where both VBA and non-VBA solution is provided.

Out of curiosity, I have created a similar spreadsheet based on a series of lookups to perform the spelling function as per below.

How it works basically is:

1) Breakup the number into classes of 000 (thousands, millions etc)

2) Spelling out the number for the respective classes through vlookup

3) Tag the respective classes with its respective unit category before combining all together.

Download File