| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can the "convert" function in excel convert to UK gallons?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is ther no "Convert" function available in excel? | Excel Worksheet Functions | |||
| function to convert number to words [ 21 = "twenty one " ] | Excel Worksheet Functions | |||
| convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
| can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions | |||
| Why does excel convert my text "6990011011234" to "6.99E+12"? | Excel Discussion (Misc queries) | |||
Linear Mode
