# Thread: Conversion Functions (Excel 2000 >)

1. ## Conversion Functions (Excel 2000 >)

Hi all;

I recently compiled a list of conversion formulas and spent a little time creating some Excel Functions from them. After setting up the functions, I saved the file as an attachment. If you have the need to enhance Excels function capabilities, feel free to copy the Add-In attachment and save it to your hard drive!

Before you can use an add-in, you must first install it on your computer and then load it into Excel. Add-ins (*.xla files) are installed by default in one of the following places:

1. The Documents and Settings/<user name>/Application Data/Microsoft/AddIns folder.
2. The Library folder or one of its subfolders in the Microsoft Office/Office folder.

After installing an add-in in the above folder, you must load it into Excel. Loading an add-in makes the feature available in Excel and adds any associated commands to the appropriate menus. To do this go to the TOOLS MENU and click on Add-Ins. Check the Conversion Functions checkbox. This will activate the Add-In and install the conversion functions into the Information Category of the Insert Function Dialog Box.

I hope these functions can be of use to you. If you have more conversions, feel free to let me know and we can upgrade the Add-In as needed!

Cheers

2. ## Re: Conversion Functions (Excel 2000 >)

You add-in contains a number of specific conversions that will come in handy for people who need them.

Did you know that the Analysis ToolPak add-in that comes with Excel contains a worksheet function CONVERT?
For example, <code>=CONVERT(120,"mm","in")</code> will convert 120 millimeters to inches.
And <code>=Convert(68,"F","C")</code> will convert 68 degrees Fahrenheit to degrees Celsius (not Celcius)

The CONVERT function generally uses more precise conversion constants than your add-in. However, it is not very convenient for compound units such as PSI, that's much easier with your add-in.

3. ## Re: Conversion Functions (Excel 2000 >)

Well, that is a new one. I've never encountered the CONVERT function. Thanx for sharing that! I'm gonna play around with that to see what its capabilities are!
CHEERS

4. ## Re: Conversion Functions (Excel 2000 >)

So that explains <post#=493,540>post 493,540</post: >

Anyway, nice touch. Safely stored away for future use when I need to work out density of my database <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

5. ## Re: Conversion Functions (Excel 2000 >)

Yeah, it was the beginnings of a long and arduous conversions trip!!

I feel quite converted myself too!!! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

6. ## Re: Conversion Functions (Excel 2000 >)

Rudi

Thanks for making your add-in available. If you're after more ammunition, you might want to check out joshmadison's convert, which is handy <img src=/S/free.gif border=0 alt=free width=30 height=15>ware standalone program in its own right. Myself, I've been working on a project for the building industry, with some of the most obscure units I've encountered since cubits and pecks. Some of them are driving me nuts <img src=/S/nuts.gif border=0 alt=nuts width=15 height=15>.

Alan

7. ## Re: Conversion Functions (Excel 2000 >)

Pleasure Alan.

Cheers for the link....Though I doubt I'll need more than what I put into the Add-In...its handy to know of freeware programs that can give more info too!
<img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

8. ## Re: Conversion Functions (Excel 2000 >)

Hi Rudi

I installed you conversion function, put it in both the places you advised now excel will not open without an error I click on debug and this line of the function is highlighted

Application.MacroOptions Macro:="Cv_EP_Rating", Category:=9

1. The Documents and Settings/<user name>/Application Data/Microsoft/AddIns folder.
2. The Library folder or one of its subfolders in the Microsoft Office/Office folder.

Regards

9. ## Re: Conversion Functions (Excel 2000 >)

You need only install the .xla in the first location, not in both.

Rudi doesn't seem to be online today, so I took the liberty to create a slightly modified version based on an article by Laurent Longre. It assigns the functions to a custom category "Conversion functions". I didn't bother putting in elaborate descriptions, I'll leave that for Rudi.

Unzip the .xla from the attachment to this post into your Cocuments and Settings<user name>Application DataMicrosoftAddIns folder.

10. ## Re: Conversion Functions (Excel 2000 >)

Hans That is a gem of a link. That could be a nice star post as I sometimes see other Loungers asking about add-ins.

11. ## Re: Conversion Functions (Excel 2000 >)

The site has been mentioned before in this forum. It is really worth a visit - I recommend the Morefunc add-in, very useful functions.

12. ## Re: Conversion Functions (Excel 2000 >)

<img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>Playing with it as we speak

13. ## Re: Conversion Functions (Excel 2000 >)

Hi Hans

I removed Rudi's Function and then loaded the one you supplied, but I still get this error, I would add that this error only appears if I have the function loaded, If I remove it
everything is OK

14. ## Re: Conversion Functions (Excel 2000 >)

First, clear the check box for the Conversion Functions add-in in Tools | Add-Ins...
Quit Excel.
Now, delete ALL instances of Conversion Functions.xla from you hard disk.
To be on the safe side, download the zip file from my previous reply anew.
Copy the .xla from the zip file to your Cocuments and Settings...AddIns folder.
Start Excel.
Select Tools | Add-Ins...
Tick the check box for Conversion Functions.
Click OK
Quit and restart Excel. The problem shouldn't occur now.

15. ## Re: Conversion Functions (Excel 2000 >)

HI Hans

That worked fine, everything now OK.

Many thanks