Re: Text

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 07/26/04 

Date: Mon, 26 Jul 2004 21:38:38 +0200

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 

--
Regards
Frank Kabel
Frankfurt, Germany
John wrote:
> 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
Quantcast