Content: sumprop.zip (17.99 KB)
Uploaded: 20.11.2009

Positive responses: 2
Negative responses: 0

Sold: 14
Refunds: 0

$0.2
Amount in words in Excel can be useful as accountants, economists, managers, and many others, are actively using Microsoft Office Excel in their daily activities. It is distributed free Interenet macro for Excel, which automates the amount of words in print spreadsheets. You can display sums in Russian rubles, US dollars, euro and hryvnia. You can also get a version of the macro in the Ukrainian language - the amount of words in the Ukrainian language.

In most cases, the most useful add-in, which extends the macro, but sometimes there are problems with the connection of the superstructure.

The superstructure contains a macro to display the amount of words in Russian (sumprop.xla)

Guidelines for setting up and using the add.

Once you have downloaded to your computer add-on you want to place the file in the folder that contains additional superstructures. The exact path to this folder depends on the version of Excel, but it will likely be similar to this:

C: \\ Documents and Settings \\ User \\ Application Data \\ Microsoft \\ AddIns,

where instead of the User must substitute the user name Windows.

Application Data folder may be hidden, that is not visible when viewed in Windows Explorer Windows. As her show - you can find out by reading tips.

The easiest way to accommodate the downloaded add-ins in the folder you selected in the Excel menu command Tools - Add-ins in the dialog that appears, click Browse. This will open a file selection dialog with the superstructure, and the current will be the desired folder (AddIns):

Start Windows Explorer and drag the downloaded add-in with the mouse icon file from Windows Explorer to open dialogue. The file is now with the necessary add-in is in the correct folder. Click it and click OK, to close the dialog. The list of available add-ins should appear amount in words. Check the box next to the line, and then click OK, and you can use the print function of the amount of words in Excel:

Using add-ins Amount in words

Working with the superstructure is done through the use of functions of Excel.

Paste function can, using the menu Insert - Function ... or by clicking fx, on the left side of the formula bar. Whichever way it was not caused by a Function Wizard in the dialog you need to choose the category User-defined:

After selecting the desired function, press OK, to go to the next wizard dialog functions. It specified the arguments, so you have to enter the number that will be converted to speech. Value can be entered directly, or refer to the cell in which that value is located. By clicking OK, you close the dialog box and paste the results into the current cell.
No feedback yet