Text

  • Thread starter Thread starter John
  • Start date Start date
J

John

This might sound like a crazy question, but if excel can
do this it would be amazing.

If you type a dollar amount in cell A1, can you have cell
A2 put it in words??

Example: A1 = $10.00. A2= Ten dollars
 
Hi
there're some macros/procedures to convert numbers to text. e.g.
MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
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
 
Back
Top