PDA

View Full Version : Amount in word



excelliot
01-05-2006, 11:32 PM
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.

johnske
01-06-2006, 12:27 AM
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)

Bob Phillips
01-06-2006, 03:30 AM
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.

See http://www.xldynamic.com/source/xld.xlFAQ0004.html