Number references

  • Thread starter Thread starter gilbert
  • Start date Start date
G

gilbert

Gee...something just flash through my mind....I wonder if there is an
Excel formula that can automatically word out the number you keyed int
a particular cell? For example, in cell A1, I entered $1,000. I nee
Excel to return "One Thousand Dollar" in cell B1. Is there anyway w
can go about it?

Please advise if you know
 
gilbert

No built-in Function, but you can build your own User Defined Function using
the info at:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213360

OR download Laurent Longre's MOREFUNC.XLL from here:

http://longre.free.fr/english/index.html

Has a Numbers to Words Function along with many other useful Functions.

And a couple more from Andy Wiggins for good measure........

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods to convert numbers to words and two cheque writing
routines.

Gord Dibben Excel MVP
 
Back
Top