Convert-IT On-Line Help

Convert-It

To run Convert-IT, proceed to the EMAGENIT toolbar and click the Convert-IT button. In Excel 2007, proceed to the Add-Ins tab and click Convert-IT. The program will prompt you with two screens, follow the instructions. On the second screen which is the Information screen, leave the Convert-IT product ID box blank to run the program in demo mode. The program will allow you to click the "Change Button" 20 times before prompting for a Convert-IT product ID which can be purchased from EMAGENIT.

Our Convert-IT Excel add-in allows you to select multiple ranges of Excel worksheet data then perform math or text concatenation operations on that data quickly. Convert-IT allows you to perform simple math operations like addition, subtraction, multiplication and division at the click of a button. Convert-IT even allows you to type a worksheet like custom formula to perform complex math or concatenation operations on your data. When outputting your results, Convert-IT allows you to overwrite your selected cells, output to a new worksheet range or combine existing formulas with the Convert-IT math operations being performed.

To open Convert-IT in Microsoft Excel, go to the Windows start button and click it, select the EMAGENIT grouping under programs, click on the Convert-IT icon and it will open in Microsoft Excel. If prompted, click the Enable Macros button to enable the program. Once open in Excel, proceed to the EMAGENIT toolbar in Excel 2003 and below and click the Convert-IT button. In Excel 2007, proceed to the Add-Ins tab and click the Convert-IT button.

If Convert-IT will not run in Microsoft Excel and prompts you as such, your macros have been disabled. To enable macros, proceed to Microsoft Excel Help and type in Enable Macros and follow the instructions about enabling macros. Note that you will have to shut down Excel and re-launch Convert-IT in most instances after adjusting these settings. Note that Convert-IT cannot override Microsoft Macro security so there is no way for our program to control this feature and enable it for you. If it could be done, we would have done it for you.

Convert-IT automatically prompts you to purchase it after clicking the "Convert Button" 20 times by redisplaying its setup Information screen. You can purchase the software by clicking the purchase button on the screen then clicking the purchase button on the website page that is displayed. EMAGENIT will send you the product-ID within 2 hrs during our operating hrs Mon-Fri 8:00 AM-4:00 PM PST. You can also purchase it by clicking on the Purchase button to the left. To key in the product-ID, just launch Convert-IT and type the ID in the Information screen in the Product-ID box at the bottom.

To perform simple math operations on cells containing numeric values:

1.  Click the Convert-IT button on the EMAGENIT toolbar.

2.  If outputting to a different workbook, tile the source workbook containing the desired cell values to manipulate and the output workbook. This can be done using the Window/Arrange command in Excel.

3.  Check the Overwrite… checkbox in the Output options area to overwrite your cell selections.

4.  To output to another range, activate the desired worksheet then click on the beginning output cell. Next uncheck the Overwrite… checkbox and click the ...output cell box. This designates the desired beginning output cell. Note that any cell information in the output range will be overwritten.

5.  Activate the worksheet whose cell values you want to convert.

6.  Select the range containing the data to manipulate. If the data is in non-adjacent ranges, select the first column or row; hold down the CTRL key then select the other ranges. Note that the Undo feature retains its last memory even if you close Convert-IT and reopen it or are even in another workbook. Also note that the Undo feature will only work on a maximum of 2000 cells. This is a memory constraint.

7.  Click the multiplication, division, subtraction, addition or power buttons.

8.  In the Operation value box, type in the value you wish to multiply, divide, subtract… by.

9.  Check the Keep… box if you wish to integrate existing cell formulas with the conversion factor. If you choose this option, the existing cell formula will be wrapped in parenthesis then the appropriate operation and operation value placed after the parenthesis. Note that in this mode, cell constants are simply converted without modification.

10.  Click the Convert button.

*Note that when using the multiplication, division, subtraction, addition or power buttons modes, Convert-IT will ignore cell’s displaying error values and cells containing text values. If you want to manipulate cells containing text values, consult the text concatenation section.

*Note that Convert-IT treats empty cells as 0 values.

To perform complex math operations on cell values:

1.  Click the Convert-IT button on the EMAGENIT toolbar.

2.  If outputting to a different workbook, tile the source workbook containing the desired cell values to manipulate and the output workbook. This can be done using the Window/Arrange command in Excel.

3.  Check the Overwrite… checkbox in the Output options area to overwrite your cell selections.

4.  To output to another range, activate the desired worksheet then click on the beginning output cell. Next uncheck the Overwrite… checkbox and click the ...output cell box. This designates the desired beginning output cell. Note that any cell information in the output range will be overwritten.

5.  Activate the worksheet whose cell values you want to convert.

6.  Select the range containing the data to manipulate. If the data is in non-adjacent ranges, select the first column or row; hold down the CTRL key then select the other ranges. Note that the Undo feature retains its last memory even if you close Convert-IT and reopen it or are even in another workbook. Also note that the Undo feature will only work on a maximum of 2000 cells. This is a memory constraint.

7.  Click the Custom button to create a custom formula.

8.  To perform a complex math operation on a cell value, type a custom formula in the custom formula box like you would a formula in a worksheet cell. Note that you leave off the = sign at the beginning. You may use cell references, cell names and even worksheet and VBA UDF functions. Wherever you want the cell value to be used in the formula, type the characters vln. When Convert-IT is run, the vln text will be replaced by the cell value. The custom formula itself will be output to the cell. For example, to multiply a cell value by 2 then divide by 3, the formula would be vln*2/3. Note that all cell references are treated as absolute references in the program regardless of notation.

9.  Check the Keep… box if you wish to integrate existing cell formulas with the custom formula. The existing cell formula will appear were you type the vln text. If you choose this option, the existing cell formula will be wrapped in parenthesis then inserted. Note that in this mode cell constants are inserted without modification.

10.  Click the Convert button.

*Note that in the custom mode, Convert-IT will ignore cell’s displaying error values. If you want to manipulate cells containing text values, consult the text concatenation sectionconcat.

*Note that Convert-IT treats empty cells as 0 valuesconcat.

A concatenation operation occurs when you want to join two or more pieces of data together to become one. For example, a concatenation you might want to perform is to build a date out of cell values and numbers or to join a piece of text to an existing cell text value. Convert-IT allows you to do this using its Custom feature. To perform a concatenation operation using Convert-IT:

1.  Click the Convert-IT button on the EMAGENIT toolbar.

2.  If outputting to a different workbook, tile the source workbook containing the desired cell values to manipulate and the output workbook. This can be done using the Window/Arrange command in Excel.

3.  Check the Overwrite… checkbox in the Output options area to overwrite your cell selections.

4.  To output to another range, activate the desired worksheet then click on the beginning output cell. Next uncheck the Overwrite… checkbox and click the  ...output cell box. This designates the desired beginning output cell. Note that any cell information in the output range will be overwritten.

5.  Activate the worksheet whose cell values you want to convert.

6.  Select the range containing the data to manipulate. If the data is in non-adjacent ranges, select the first column or row; hold down the CTRL key then select the other ranges. Note that the Undo feature retains its last memory even if you close Convert-IT and reopen it or are even in another workbook. Also note that the Undo feature will only work on a maximum of 2000 cells. This is a memory constraint.

7.  Click the Custom button to create a custom formula.

8.  To perform a concatenation operation on a cell value, type a custom formula in the custom formula box like you would a concatenation formula in a worksheet cell (consult Excel help on building concatenation formulas). Note that you leave off the = sign at the beginning. You may use cell references, cell names, worksheet functions and even VBA UDF functions. Where ever you want the cell value to be used in the formula, type the characters vln. When Convert-IT is run, the vln text will be replaced by the cell value. The custom formula itself will be output to the cell. For example, to add text in front of a cell value, a possible concatenation formula might be “The number obtained is ” & vln. Note that all cell references are treated as absolute references in the program regardless of notation. Note that there are many ways to perform concatenation. Consult the 

9.  Check the Keep… box if you wish to integrate the existing cell formulas in your selection with the custom formula. The existing cell formula will appear were you type the vln text. If you choose this option, the existing cell formula will be wrapped in parenthesis then inserted. Note that in this mode, cell constants are inserted without modification.

10.  Click the Convert button.

*Note that in the custom mode, Convert-IT will ignore cell’s displaying error values.

*Note that Convert-IT treats empty cells as 0 values.

*Note that Convert-IT will set your Excel calculation settings to manual while working. It will reset them to automatic when completed.

Convert-IT closes when Microsoft Excel closes and does not reopen with it. This is by design. To close Convert-IT so it is no longer present in Excel without closing Excel, just check the Quit check box at the bottom of its screen then click the Close button. This will remove Convert-IT from Excel.