how to write sum of numbers in letters?

[Omar Mounier]

Hello ...
I'm making an excel sheet for the sum of curruncies i got in my box ... and
i want to automaticly write the sum of the currency i have in letters ... is
there any function or macro script to make this task ??!!!

 

[Mike H]

Hi,

have a look here.

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

Mike

 

[Stefi]

Or here:
http://xldynamic.com/source/xld.xlFAQ0004.html

Regards,
Stefi

„Mike H†ezt írta:

 

[Dave Curtis]

Hi,

Or try the very useful =NBTEXT function, available as part of the "morefunc"
add-in download. You can even choose which language to use.

Dave