How do I convert number into full text amount
 

I want to use Excel to print cheque, I want to know if I can convert the
number into text amount, e.g. 500 convert into Five Hundred.

Thanks and regards

How do I convert number into full text amount
 

See Bob Phillips' site for methods.

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


Gord Dibben MS Excel MVP


On Sat, 28 Apr 2007 11:10:01 -0700, HONG KONG CHE <HONG KONG
wrote:

I want to use Excel to print cheque, I want to know if I can convert the
number into text amount, e.g. 500 convert into Five Hundred.

Thanks and regards