I think I'd just use formulas:

To convert imperial gallons to liters, multiply by 4.55
To convert liters to imperial gallons, multiply by 0.22

http://www.saudia-online.com/conversion%20Table.htm

(But I got lots of hits when I searched Google for "imperial gallon convert".)

Dave Gibson wrote:

Can anyone assist me in creating a couple of custom VBA functions that
will convert liters to Imperial Gallons & Vice Versa.

I got a shock on my car fuel consumption until I realised that the
inbult Excel CONVERT function was operating on US Gallons

Thanks

--

Dave Peterson