Amount in words in Excel documents

Pay with:
i agree with "Terms for Customers"
Sold: 0
Uploaded: 13.01.2016
Content: Сумма прописью в документах Excell.pdf 1004,86 kB

Delivery Guaranteed

If you are unhappy with a product you purchased, the seller will return your money within 3 days from the moment of purchase.


In Excel documents is often necessary in a particular cell type a number in words. Of particular need for this experience financiers and accountants. Most users, without delving into the issue, just typing on a keyboard, and find it quite normal. However, the process recipe set manually is time consuming, requires special attention, as there is a large proportion of the risk of making a mistake.
Another way in which it is acceptable for users Excell - is found on the Internet ready module, connect it to your program and use. However, in this case, your computer can be subjected to the danger of the introduction of malicious software that hackers always hide under the innocuous macros. Is not it better to make an adjustment program with their own hands? Algorithm development costs, literally, an hour of time, the user will solve the problem for many subsequent years of operation.
In this paper I suggest the reader to create his own hands module fully automates a set amount of words in documents created with the help of the program Excell. The basis of the amount of automation in words, in this paper, taken the Russian currency (rubles and kopecks). Russian language, and it is recognized by all, is one of the most difficult languages ​​in the world. That is only to decline a noun rubles and kopecks. Look 1 ruble 2 rubles 5 rubles, 1 penny, two a penny, 5 cents. Two words give six different recipe.
Having mastered the decline of the Russian currency, each user can easily adjust the recipe for its regional currency. The algorithm for writing many of the former Soviet Union will be much easier, as in many languages, such declines do not carried out. Assume Uzbek word for "sum" is not inclined, so would be the sum 1, 2 and 5, sum sum, and so on. Naturally, this recipe, unlike setting Russian ruble will carry much

Additional information

All processing of numbers and their translation in the capital state will be carried out exclusively by means of the built-in program functions without touching programming in Visual Basic. In this paper, you can use Microsoft Excell 2002, Excell 2003, Excell 2007, Excell 2010 and later implementation of the spreadsheet.
For Russian readers who are not interested in computing, produced built-in functions, but just want their program to work and conclusions of the amount of words, at the end of the book posted application. It shows the names of cells and formulas that can be copied to the cell. The program will then be run correctly, bringing the amount of words in any user-specified location.


No feedback yet.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)