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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.