View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Convert figure to words

Hi,

Install the Morefunc addin which will provide many new Excel functions
including =NBTEXT()
Which does number to words conversions.

http://xcell05.free.fr/english/

alternatively do it with code


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

Mike

Mike

"Ashish Saxena" wrote:

I want to convert an amount like 587 to Five hundred Eighty Seven. How Pl. help