how to convert the numeric or amount in figure to word or inwords

[die hard]

how to convert the numeric or amount in figure to word or amount in words
exmple : the amount in figure is 1,000.00 then in words One thousand pesose
only.

 

[Gary''s Student]

See:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360&

 

[Mike H]

Hi,

Another option is to instal the excellent Morefunc addidn and you get among
other things the =NBTEXT() function which will do this in 13 languages. have
a look here.

http://xcell05.free.fr/morefunc/english/index.htm

Mike