Changing numbers to text

[Guest]

How do i change the string of number into text. (Not just the format)

When i key in "US$1,234.00", another cell will appear "United States Dollars
One Thousand Two Hundred Thirty Four only."

 

[Guest]

Take a look at these sites:

http://support.microsoft.com/default.aspx?scid=kb;en-us;213360

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

http://www.ozgrid.com/VBA/ValueToWords.htm

HTH