Hi,
I want to convert amount in words, can anyone help me in formula?
Thanks,
Rahul
Hi,
I want to convert amount in words, can anyone help me in formula?
Thanks,
Rahul
Last edited by rchure; 09-02-2014 at 01:24 AM.
Use the search option on the forum.
I found this one, with the search option.
I know there must be more examples, but this probably will do.
http://www.excelforum.com/excel-gene...-to-words.html
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi,
Thanks for your reply..
i am aware of the above code.
There are any other way to convert amount in number without using macro, i mean to say any formula.
Thanks
The link provides both: (1) a further link to a User-Defined Function (not a macro) from MS; and (2) a workbook with a formula using it. What more do you need?
I doubt you'll find anyone willing to waste their time trying to do this using only Excel's built-in formula functions.
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
In that case it is usefull to add that information in your question, so forumpeople don't have to look for that kind of solution.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks