View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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