I search the web and found a way to convert currency to words, but its not in a format I want.
e.g: $999.09 is converted to "Nine Hundred ninety nine dollars and nine cents", how can I change the format to Dollars Nine Hundred ninety nine and Cents nine only"?
Here is one solution, IT IS a long formula but it works. Number in cell A1 has to be formatted as text. This works up to 9999.99
Yes it will. we just have to figure out how...
If I have helped you, PLEASE click the * and add to my Rep.
Also, if the problem is SOLVED please mark it as so.
I am working on this more. The posted version is not working...
care to share what you are using? it could then maybe be modifiedI search the web and found a way to convert currency to words
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
you could try this ugly 'MONSTER', works to 9,999,999,999,999.99 (which is the 15 digits of significance Excel allows.it will go to 999,999,999,999,999.00 as long as your willing to lose the pennies and dimes as you get larger, I am working on a better one)
(Note- My original formula for this uses named arrays and named formulas to shorten the actual formula)
Formula:
Please Login or Register to view this content.
Hope this helps
EDIT-
RECQUIRES 2007 or higher, this particular version is 1700-1800 characters long, so pre 2007 versions will not accept it (as I said, still working on a better one)
Edit 2 -
Closer to 8000 chars, sorry
Last edited by dredwolf; 03-31-2013 at 10:55 PM.
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
THANK YOU SO MUCH!!! This helped me for my bid due today.
Here is a lot smaller formula that works to 9999.99
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks