On Tue, 3 Mar 2009 10:48:00 +1000, "MartinW" wrote:

Hi Pete,

You can take a look at the CONVERT function in the help file, however
I don't think that will do it for you.

You can just do it manually, here are the conversion factors from Google.
1 US gallon = 0.133680556 cubic feet
1 Imperial gallon = 0.16054372 cubic feet

HTH
Martin





Well, you *should* be able to do it using the CONVERT function and some math,
but it comes up with an incorrect answer.

=CONVERT((CONVERT(A1,"gal","l")*1000)^(1/3),"cm","ft")^3

The error is in the very first conversion. The problem is that the CONVERT
function does not seem to properly convert gallons to liters (nor does it
properly convert quarts to liters (unless MS is using a different standard).

Of course, the error introduced is small, resulting in an Excel derived
conversion factor of 0.133709643 rather than the 0.133680556 that seems to be
correct.
--ron