ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to write sum of numbers in letters? (https://www.excelbanter.com/excel-discussion-misc-queries/221264-how-write-sum-numbers-letters.html)

Omar Mounier

how to write sum of numbers in letters?
 
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

how to write sum of numbers in letters?
 
Hi,

have a look here.

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

Mike

"Omar Mounier" wrote:

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 ??!!!


Stefi

how to write sum of numbers in letters?
 
Or he
http://xldynamic.com/source/xld.xlFAQ0004.html

Regards,
Stefi

€˛Mike H€¯ ezt Ć*rta:

Hi,

have a look here.

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

Mike

"Omar Mounier" wrote:

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 ??!!!


Dave Curtis[_2_]

how to write sum of numbers in letters?
 
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

"Omar Mounier" wrote:

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 ??!!!



All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com