Routines or functions to do conversions

[Huck Rorick]

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

 

[Gord Dibben]

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

 

[Huck]

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

 

[Gord Dibben]

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