R
Reacher
when I use auto calculations to convert Litres to gallons it gives the answer
in us gallons instead of uk .My regional settings are ok,
in us gallons instead of uk .My regional settings are ok,
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sandy Mann
Divide the Litres by 4.54609 to convert them into UK gallons. With the
Litres in A1 to convert to UK gallons roiunded to the nearest 2
decimalplaces use:
=ROUND(A1/4.54609,2)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
[email protected]
Replace @mailinator.com with @tiscali.co.uk
Litres in A1 to convert to UK gallons roiunded to the nearest 2
decimalplaces use:
=ROUND(A1/4.54609,2)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
[email protected]
Replace @mailinator.com with @tiscali.co.uk
B
Bob Phillips
That is a feature of Convert. Multiply by .8 to get UK gallons.
M
MartinW
Hi Reacher,
For litres to imperial gallons.
Excel 2000 only has a "uk_pt" option, I don't know if
later versions have a "uk_gal" however you can use the
pint and divide by 8 like this,
=CONVERT(A1,"l","uk_pt")/8
HTH
Martin
For litres to imperial gallons.
Excel 2000 only has a "uk_pt" option, I don't know if
later versions have a "uk_gal" however you can use the
pint and divide by 8 like this,
=CONVERT(A1,"l","uk_pt")/8
HTH
Martin