uk gallons

[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,

 

[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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Bob Phillips]

That is a feature of Convert. Multiply by .8 to get UK gallons.

 

[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