uk gallons

  • Thread starter Thread starter Reacher
  • Start date Start date
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,
 
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
 
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
 
Back
Top