Ask Experts Questions for FREE Help !
Ask
    rockfortvijay's Avatar
    rockfortvijay Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jan 24, 2014, 08:02 AM
    What is the formula for converting numbers in words?
    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's Avatar
    ebaines Posts: 12,131, Reputation: 1307
    Expert
    		  
    #2

    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
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Formula for converting 32 bit Hexadecimal into decimal in EXCEL [ 23 Answers ]

Formula for converting 32 bit Hexadecimal into decimal in EXCEL. I required a formula in the mSEXCEL for cinverting IEEE-754 32bit hexadecimal floating point representation into decimal floating point.

Converting numbers to spelling and speech [ 2 Answers ]

How spell and say $ 434,234.11?

How do I create formula for sequential numbers in Excel? [ 1 Answers ]

I need a macro so that every time I open the same excel file it increases my invoice number by 1 and saves the file. e.g. on opening file invoice number changes for alb00001 to alb00002 to alb00003 and so on

Want to get numbers to repeat in a spreadsheet like words do. [ 3 Answers ]

If I type a word in a cell on the spreadsheet, and further down the column if I type the beginning letter of that word, it will repeat. However, that only works with words. I cannot find a way to get a number to repeat in that same fashing. I have two columns where a certain number is used...

View more questions Search