|
Posted to microsoft.public.excel.misc
|
|
|
convert figure into word
useful link:-
http://www.xldynamic.com/source/xld.xlFAQ0004.html
somethinglikeant
Ankur wrote:
Hi,
I am working in accounts dept and have to prepare excel invoices daily. I
have to write the total amount of invoice both in figures and words, right
now i m manually writing the amount in words. Is there any formula to convert
the figures to words? The amount to be written in USD for eg. Two thousand
fifty and 50/100 cents.
Many thanks in advance.
Regards,
Ankur
|