Is it possible to give amount in word for given amount in figure in cell.
E.g. =inword(1,000.50) give
$ One thousand & Cents Fifty Only.
Is it possible to give amount in word for given amount in figure in cell.
E.g. =inword(1,000.50) give
$ One thousand & Cents Fifty Only.
A mighty flame followeth a tiny sparkle!!
I thought I saw this in the KB but I can't find it.
EDIT: Bad link, try the one above...
DOUBLE EDIT: Dammit, that's not working either, but do a Google search for "vba excel numbers to words" and follow the Ozgrid link (should be the 1st link)
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
See http://www.xldynamic.com/source/xld.xlFAQ0004.htmlOriginally Posted by excelliot