can the "convert" function in excel convert to UK gallons?
 

can the "convert" function in excel convert to UK gallons?
 

From what?

Litres =CONVERT(E14,"l","uk_pt")/8

US Gall = CONVERT(E14,"gal","uk_pt")/8

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"JR" wrote in message
...

can the "convert" function in excel convert to UK gallons?
 

Not directly, but try uk_pt and divide the result by 8.
--
David Biddulph

"JR" wrote in message
...