Volume Unit Converter in Excel

1 millilitre = 1.000000000E-009 thousand cubic metre

Formula for this pair

These units are a straight multiple of each other. Put the starting value in cell A1.

=A1*1.000000000E-009

Once you have saved the function below, type this in a cell

=ConvertVolume(1, "ml", "1000 m3")

CONVERT

Excel's CONVERT function has no code for thousand cubic metre (1000 m3). Use the formula above. It uses this site's conversion factors.

How to save as a reusable Excel function

Microsoft 365. No VBA and no add-in.

  1. Open the function below and copy it. It has no call at the end.
  2. On the Formulas tab, choose Name Manager, then New.
  3. Set the name to ConvertVolume. Leave the scope as Workbook.
  4. Paste the function into Refers to.
  5. In a cell, type the call shown above.

ConvertVolume

Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"m3",1,"1000 bbl",158.987294928,"1000 ft3",28.316846592,"1000 gal[UK]",4.54609,"1000 gal[US]",3.785411784,"1000 m3",1000,"E3m3",1000,"1E-6 gal[US]",3.785411784E-9,"1E12 ft3",28316846592,"1E6 bbl",158987.294928,"1E6 ft3",28316.846592,"1E6 m3",1000000,"E6m3",1000000,"1E9 bbl",158987294.928,"1E9 ft3",28316846.592,"L",0.001,"acre.ft",1233.486771489672,"bbl",0.158987294928,"cm3",0.000001,"dm3",0.001,"floz[UK]",0.0000284130625,"floz[US]",0.0000295735295625,"ft3",0.028316846592,"gal[UK]",0.00454609,"gal[US]",0.003785411784,"hL",0.1,"ha.m",10000,"in3",0.000016387064,"km3",1000000000,"mL",0.000001,"mi3",4168181825.4405794,"mm3",1E-9,"pt[UK]",0.00056826125,"pt[US]",0.000473176473,"qt[UK]",0.0011365225,"qt[US]",0.000946352946,"um2.m",1E-12,"yd3",0.764554857984,"SM3",1,"l",0.001,"ml",0.000001,"gal",0.003785411784,"mbbl",158.987294928,"mmbbl",158987.29492800002,"scf",0.028316846592,"mscf",28.316846592,"mmscf",28316.846592,"bcf",28316846.592,"STB",0.158987294928,"stb",0.158987294928,"BBL",0.158987294928,"MSTB",158.987294928,"mstb",158.987294928,"MMSTB",158987.29492800002,"mmstb",158987.29492800002,"SCF",0.028316846592,"MSCF",28.316846592,"MMSCF",28316.846592,"BCF",28316846.592,"cup[US]",0.0002365882365,"cup[UK]",0.000284130625,"cup[metric]",0.00025,"tbsp[US]",0.00001478676478125,"tbsp[UK]",0.00001420653125,"tbsp[metric]",0.000015,"tsp[US]",0.00000492892159375,"tsp[UK]",0.0000035516328125,"tsp[metric]",0.000005),fromShift,SWITCH(from_unit,"m3",0,"1000 bbl",0,"1000 ft3",0,"1000 gal[UK]",0,"1000 gal[US]",0,"1000 m3",0,"E3m3",0,"1E-6 gal[US]",0,"1E12 ft3",0,"1E6 bbl",0,"1E6 ft3",0,"1E6 m3",0,"E6m3",0,"1E9 bbl",0,"1E9 ft3",0,"L",0,"acre.ft",0,"bbl",0,"cm3",0,"dm3",0,"floz[UK]",0,"floz[US]",0,"ft3",0,"gal[UK]",0,"gal[US]",0,"hL",0,"ha.m",0,"in3",0,"km3",0,"mL",0,"mi3",0,"mm3",0,"pt[UK]",0,"pt[US]",0,"qt[UK]",0,"qt[US]",0,"um2.m",0,"yd3",0,"SM3",0,"l",0,"ml",0,"gal",0,"mbbl",0,"mmbbl",0,"scf",0,"mscf",0,"mmscf",0,"bcf",0,"STB",0,"stb",0,"BBL",0,"MSTB",0,"mstb",0,"MMSTB",0,"mmstb",0,"SCF",0,"MSCF",0,"MMSCF",0,"BCF",0,"cup[US]",0,"cup[UK]",0,"cup[metric]",0,"tbsp[US]",0,"tbsp[UK]",0,"tbsp[metric]",0,"tsp[US]",0,"tsp[UK]",0,"tsp[metric]",0),toFactor,SWITCH(to_unit,"m3",1,"1000 bbl",158.987294928,"1000 ft3",28.316846592,"1000 gal[UK]",4.54609,"1000 gal[US]",3.785411784,"1000 m3",1000,"E3m3",1000,"1E-6 gal[US]",3.785411784E-9,"1E12 ft3",28316846592,"1E6 bbl",158987.294928,"1E6 ft3",28316.846592,"1E6 m3",1000000,"E6m3",1000000,"1E9 bbl",158987294.928,"1E9 ft3",28316846.592,"L",0.001,"acre.ft",1233.486771489672,"bbl",0.158987294928,"cm3",0.000001,"dm3",0.001,"floz[UK]",0.0000284130625,"floz[US]",0.0000295735295625,"ft3",0.028316846592,"gal[UK]",0.00454609,"gal[US]",0.003785411784,"hL",0.1,"ha.m",10000,"in3",0.000016387064,"km3",1000000000,"mL",0.000001,"mi3",4168181825.4405794,"mm3",1E-9,"pt[UK]",0.00056826125,"pt[US]",0.000473176473,"qt[UK]",0.0011365225,"qt[US]",0.000946352946,"um2.m",1E-12,"yd3",0.764554857984,"SM3",1,"l",0.001,"ml",0.000001,"gal",0.003785411784,"mbbl",158.987294928,"mmbbl",158987.29492800002,"scf",0.028316846592,"mscf",28.316846592,"mmscf",28316.846592,"bcf",28316846.592,"STB",0.158987294928,"stb",0.158987294928,"BBL",0.158987294928,"MSTB",158.987294928,"mstb",158.987294928,"MMSTB",158987.29492800002,"mmstb",158987.29492800002,"SCF",0.028316846592,"MSCF",28.316846592,"MMSCF",28316.846592,"BCF",28316846.592,"cup[US]",0.0002365882365,"cup[UK]",0.000284130625,"cup[metric]",0.00025,"tbsp[US]",0.00001478676478125,"tbsp[UK]",0.00001420653125,"tbsp[metric]",0.000015,"tsp[US]",0.00000492892159375,"tsp[UK]",0.0000035516328125,"tsp[metric]",0.000005),toShift,SWITCH(to_unit,"m3",0,"1000 bbl",0,"1000 ft3",0,"1000 gal[UK]",0,"1000 gal[US]",0,"1000 m3",0,"E3m3",0,"1E-6 gal[US]",0,"1E12 ft3",0,"1E6 bbl",0,"1E6 ft3",0,"1E6 m3",0,"E6m3",0,"1E9 bbl",0,"1E9 ft3",0,"L",0,"acre.ft",0,"bbl",0,"cm3",0,"dm3",0,"floz[UK]",0,"floz[US]",0,"ft3",0,"gal[UK]",0,"gal[US]",0,"hL",0,"ha.m",0,"in3",0,"km3",0,"mL",0,"mi3",0,"mm3",0,"pt[UK]",0,"pt[US]",0,"qt[UK]",0,"qt[US]",0,"um2.m",0,"yd3",0,"SM3",0,"l",0,"ml",0,"gal",0,"mbbl",0,"mmbbl",0,"scf",0,"mscf",0,"mmscf",0,"bcf",0,"STB",0,"stb",0,"BBL",0,"MSTB",0,"mstb",0,"MMSTB",0,"mmstb",0,"SCF",0,"MSCF",0,"MMSCF",0,"BCF",0,"cup[US]",0,"cup[UK]",0,"cup[metric]",0,"tbsp[US]",0,"tbsp[UK]",0,"tbsp[metric]",0,"tsp[US]",0,"tsp[UK]",0,"tsp[metric]",0),(value*fromFactor+fromShift-toShift)/toFactor))

Conversion factors

The factors this converter uses. Copy them into Excel as tab-separated values.

Symbol Name FactorExcel code
m3 cubic metre 1m3
1000 bbl thousand barrel 158.987294928—
1000 ft3 thousand cubic foot 28.316846592—
1000 gal[UK] thousand UK gallon 4.54609—
1000 gal[US] thousand US gallon 3.785411784—
1000 m3 thousand cubic metre 1000—
E3m3 thousand cubic metre 1000—
1E-6 gal[US] millionth of US gallon 3.785411784E-9—
1E12 ft3 million million cubic foot 28316846592—
1E6 bbl million barrel 158987.294928—
1E6 ft3 million cubic foot 28316.846592—
1E6 m3 million cubic metre 1000000—
E6m3 million cubic metre 1000000—
1E9 bbl thousand million barrel 158987294.928—
1E9 ft3 thousand million cubic foot 28316846.592—
L litre 0.001L
acre.ft acre foot 1233.486771489672—
bbl barrel 0.158987294928barrel
cm3 cubic centimetre 0.000001—
dm3 cubic decimetre 0.001—
floz[UK] UK fluid-ounce 0.0000284130625—
floz[US] US fluid-ounce 0.0000295735295625oz
ft3 cubic foot 0.028316846592ft3
gal[UK] UK gallon 0.00454609uk_gal
gal[US] US gallon 0.003785411784gal
hL hectolitre 0.1hL
ha.m hectare metre 10000—
in3 cubic inch 0.000016387064in3
km3 cubic kilometre 1000000000—
mL millilitre 0.000001mL
mi3 cubic mile 4168181825.4405794mi3
mm3 cubic millimetre 1E-9—
pt[UK] UK pint 0.00056826125uk_pt
pt[US] US pint 0.000473176473pt
qt[UK] UK quart 0.0011365225uk_qt
qt[US] US quart 0.000946352946qt
um2.m square micrometre metre 1E-12—
yd3 cubic yard 0.764554857984yd3
SM3 standard cubic metre 1—
l litre 0.001l
ml millilitre 0.000001ml
gal US gallon 0.003785411784gal
mbbl thousand oil barrels 158.987294928—
mmbbl million oil barrels 158987.29492800002—
scf standard cubic foot 0.028316846592—
mscf thousand standard cubic feet 28.316846592—
mmscf million standard cubic feet 28316.846592—
bcf billion standard cubic feet 28316846.592—
STB stock tank barrel 0.158987294928—
stb stock tank barrel 0.158987294928—
BBL oil barrel 0.158987294928barrel
MSTB thousand stock tank barrels 158.987294928—
mstb thousand stock tank barrels 158.987294928—
MMSTB million stock tank barrels 158987.29492800002—
mmstb million stock tank barrels 158987.29492800002—
SCF oil standart cubic feet 0.028316846592—
MSCF thousand standard cubic feet 28.316846592—
MMSCF million standard cubic feet 28316.846592—
BCF billion standard cubic feet 28316846.592—
cup[US] US cup 0.0002365882365cup
cup[UK] imperial cup 0.000284130625—
cup[metric] metric cup 0.00025—
tbsp[US] US tablespoon 0.00001478676478125tbs
tbsp[UK] imperial tablespoon 0.00001420653125—
tbsp[metric] metric tablespoon 0.000015—
tsp[US] US teaspoon 0.00000492892159375tsp
tsp[UK] imperial teaspoon 0.0000035516328125—
tsp[metric] metric teaspoon 0.000005tspm

Notes

Excel's barrel is the US oil barrel of 42 US gallons. In this catalogue that is bbl and BBL, so both use the code barrel. A stock-tank barrel has the same factor here, but CONVERT has no stb code, and it has none for scf. A prefix on m3 scales the cubic metre: cm3 is not a cubic centimetre. One millilitre is one cubic centimetre, and that uses the litre code mL, not cm3.

Google Sheets

Google Sheets has CONVERT and many of the same codes, and it has LAMBDA. Named functions are created under Data > Named functions, not Formulas > Name Manager. A code that works in Excel can return #N/A in Sheets, so try a known value before you rely on it.

Related