Take a look at these sites:

http://support.microsoft.com/default...b;en-us;213360

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

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

HTH




"Des" wrote:

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."