PDA

View Full Version : What is the formula for converting numbers in words?


rockfortvijay
Jan 24, 2014, 08:02 AM
In MS Excel, we are preparing our invoices. Finally the total amount should be in words also. For that purpose every time we have to type the words. It is a boring and leborious work to me. Kindly help me with any shortcut formulae for the above purpose please.

ebaines
Jan 24, 2014, 09:03 AM
Check out this article - it gives you code for a VBA module that seems to work pretty well:

How to convert a numeric value into English words in Excel (http://support.microsoft.com/kb/213360)