Routines or functions to do conversions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Huck Rorick - 15 Oct 2006 19:44 GMT

I do a lot of conversions of different types most frequently involving
measurements, for example from square meters to square feet, gallons to
cubic feet, etc (sometimes involving unusual measures such as Chinese mu, a
measure of area). Are there any functions or routines to do conversions?

Also, if I keep constants such as SFPerM2 (square feet per square meter), is
there an easy way to make them quickly accessible to all my spreadsheets or
new spreadsheets?

Thanks for any help

Huck

Reply to this Message

Gord Dibben - 15 Oct 2006 21:14 GMT

Excel has a Convert Function in the Analysis Toolpak.

I use a handy utility called Converter, freely downloadable from this site.

http://joshmadison.net/software/convert/

FAQ page...... http://joshmadison.net/software/convert/faq.php

I created a macro to pop it up and stuck a menu item on the Tools Menu.

Sub Convert_units()
Dim taskID As Variant
On Error Resume Next
Shell ("C:\Utilities\Convert\Converter.exe"), vbNormalFocus
If Err <> 0 Then _
MsgBox "Converter.exe is Missing"
End Sub

The output can be copied to the clipboard and pasted to your sheet.

No calculations are shown however.

Gord Dibben MS Excel MVP

>I do a lot of conversions of different types most frequently involving
>measurements, for example from square meters to square feet, gallons to
[quoted text clipped - 8 lines]
>
>Huck

Reply to this Message

Huck - 15 Oct 2006 22:41 GMT

Thanks Gord. I downloaded the Convert routine. It looks nice. Have you
ever used the Analysis Toolpak Convert Function? I tried to use it, but
there was not help file and I couldn't see how to enter the units for
conversion.

Huck

> Excel has a Convert Function in the Analysis Toolpak.
>
[quoted text clipped - 40 lines]
>>
>>Huck

Reply to this Message

Gord Dibben - 16 Oct 2006 04:06 GMT

Don't know which version of Excel you are running but on 2002 and 2003 the help
gives units and examples.

Go to Help and type in Convert.

The CONVERT function help will show.

Click on it.

Gord

>Thanks Gord. I downloaded the Convert routine. It looks nice. Have you
>ever used the Analysis Toolpak Convert Function? I tried to use it, but
[quoted text clipped - 47 lines]
>>>
>>>Huck

Reply to this Message