Length Unit Converter in Excel

1 millimetre = 3.280839895E-06 thousand foot

Formula for this pair

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

=A1*3.280839895E-06

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

=ConvertLength(1, "mm", "1000 ft")

CONVERT

Excel's CONVERT function has no code for thousand foot (1000 ft). 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 ConvertLength. Leave the scope as Workbook.
  4. Paste the function into Refers to.
  5. In a cell, type the call shown above.

ConvertLength

Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"m",1,"0.1 ft",0.03048,"0.1 ft[US]",0.03048006096012192,"0.1 in",0.00254,"0.1 yd",0.09144,"1/16 in",0.0015875,"1/2 ft",0.1524,"1/32 in",0.00079375,"1/64 in",0.000396875,"10 ft",3.048,"10 in",0.254,"10 km",10000,"100 ft",30.48,"100 km",100000,"1000 ft",304.8,"30 ft",9.144,"30 m",30,"Em",1000000000000000000,"Gm",1000000000,"Mm",1000000,"Tm",1000000000000,"angstrom",1E-10,"chain",20.1168,"chain[BnA]",20.1167824,"chain[BnB]",20.116782494375872,"chain[Cla]",20.1166195164,"chain[Ind37]",20.11669506,"chain[SeT]",20.116756,"chain[Se]",20.116765121552632,"chain[US]",20.11684023368047,"cm",0.01,"dam",10,"dm",0.1,"fathom",1.8288,"fm",1E-15,"ft",0.3048,"ft[BnA]",0.3047997333333333,"ft[BnB]",0.30479973476327077,"ft[Br36]",0.3048007491,"ft[Br65]",0.30480083333333335,"ft[Cla]",0.3047972654,"ft[GC]",0.3047997101815088,"ft[Ind37]",0.30479841,"ft[Ind62]",0.3047996,"ft[Ind75]",0.3047995,"ft[Ind]",0.30479951024814694,"ft[SeT]",0.30479933333333337,"ft[Se]",0.3047994715386762,"ft[US]",0.3048006096012192,"fur[US]",201.16840233680466,"hm",100,"in",0.0254,"in[US]",0.0254000508001016,"km",1000,"link",0.201168,"link[BnA]",0.201167824,"link[BnB]",0.2011678249437587,"link[Cla]",0.201166195164,"link[SeT]",0.20116756,"link[Se]",0.2011676512155263,"link[US]",0.2011684023368047,"m[Ger]",1.0000135965,"mi",1609.344,"mi[US]",1609.3472186944373,"mi[nautUK]",1853,"mi[naut]",1852,"mil",0.0000254,"mm",0.001,"nm",1E-9,"pm",1E-12,"rod[US]",5.029210058420117,"um",0.000001,"yd",0.9144,"yd[BnA]",0.9143992,"yd[BnB]",0.9143992042898124,"yd[Cla]",0.9143917962,"yd[Ind37]",0.91439523,"yd[Ind62]",0.9143988,"yd[Ind75]",0.9143985,"yd[Ind]",0.9143985307444408,"yd[SeT]",0.914398,"yd[Se]",0.9143984146160287,"yd[US]",0.9144018288036576,"nmi",1852),fromShift,SWITCH(from_unit,"m",0,"0.1 ft",0,"0.1 ft[US]",0,"0.1 in",0,"0.1 yd",0,"1/16 in",0,"1/2 ft",0,"1/32 in",0,"1/64 in",0,"10 ft",0,"10 in",0,"10 km",0,"100 ft",0,"100 km",0,"1000 ft",0,"30 ft",0,"30 m",0,"Em",0,"Gm",0,"Mm",0,"Tm",0,"angstrom",0,"chain",0,"chain[BnA]",0,"chain[BnB]",0,"chain[Cla]",0,"chain[Ind37]",0,"chain[SeT]",0,"chain[Se]",0,"chain[US]",0,"cm",0,"dam",0,"dm",0,"fathom",0,"fm",0,"ft",0,"ft[BnA]",0,"ft[BnB]",0,"ft[Br36]",0,"ft[Br65]",0,"ft[Cla]",0,"ft[GC]",0,"ft[Ind37]",0,"ft[Ind62]",0,"ft[Ind75]",0,"ft[Ind]",0,"ft[SeT]",0,"ft[Se]",0,"ft[US]",0,"fur[US]",0,"hm",0,"in",0,"in[US]",0,"km",0,"link",0,"link[BnA]",0,"link[BnB]",0,"link[Cla]",0,"link[SeT]",0,"link[Se]",0,"link[US]",0,"m[Ger]",0,"mi",0,"mi[US]",0,"mi[nautUK]",0,"mi[naut]",0,"mil",0,"mm",0,"nm",0,"pm",0,"rod[US]",0,"um",0,"yd",0,"yd[BnA]",0,"yd[BnB]",0,"yd[Cla]",0,"yd[Ind37]",0,"yd[Ind62]",0,"yd[Ind75]",0,"yd[Ind]",0,"yd[SeT]",0,"yd[Se]",0,"yd[US]",0,"nmi",0),toFactor,SWITCH(to_unit,"m",1,"0.1 ft",0.03048,"0.1 ft[US]",0.03048006096012192,"0.1 in",0.00254,"0.1 yd",0.09144,"1/16 in",0.0015875,"1/2 ft",0.1524,"1/32 in",0.00079375,"1/64 in",0.000396875,"10 ft",3.048,"10 in",0.254,"10 km",10000,"100 ft",30.48,"100 km",100000,"1000 ft",304.8,"30 ft",9.144,"30 m",30,"Em",1000000000000000000,"Gm",1000000000,"Mm",1000000,"Tm",1000000000000,"angstrom",1E-10,"chain",20.1168,"chain[BnA]",20.1167824,"chain[BnB]",20.116782494375872,"chain[Cla]",20.1166195164,"chain[Ind37]",20.11669506,"chain[SeT]",20.116756,"chain[Se]",20.116765121552632,"chain[US]",20.11684023368047,"cm",0.01,"dam",10,"dm",0.1,"fathom",1.8288,"fm",1E-15,"ft",0.3048,"ft[BnA]",0.3047997333333333,"ft[BnB]",0.30479973476327077,"ft[Br36]",0.3048007491,"ft[Br65]",0.30480083333333335,"ft[Cla]",0.3047972654,"ft[GC]",0.3047997101815088,"ft[Ind37]",0.30479841,"ft[Ind62]",0.3047996,"ft[Ind75]",0.3047995,"ft[Ind]",0.30479951024814694,"ft[SeT]",0.30479933333333337,"ft[Se]",0.3047994715386762,"ft[US]",0.3048006096012192,"fur[US]",201.16840233680466,"hm",100,"in",0.0254,"in[US]",0.0254000508001016,"km",1000,"link",0.201168,"link[BnA]",0.201167824,"link[BnB]",0.2011678249437587,"link[Cla]",0.201166195164,"link[SeT]",0.20116756,"link[Se]",0.2011676512155263,"link[US]",0.2011684023368047,"m[Ger]",1.0000135965,"mi",1609.344,"mi[US]",1609.3472186944373,"mi[nautUK]",1853,"mi[naut]",1852,"mil",0.0000254,"mm",0.001,"nm",1E-9,"pm",1E-12,"rod[US]",5.029210058420117,"um",0.000001,"yd",0.9144,"yd[BnA]",0.9143992,"yd[BnB]",0.9143992042898124,"yd[Cla]",0.9143917962,"yd[Ind37]",0.91439523,"yd[Ind62]",0.9143988,"yd[Ind75]",0.9143985,"yd[Ind]",0.9143985307444408,"yd[SeT]",0.914398,"yd[Se]",0.9143984146160287,"yd[US]",0.9144018288036576,"nmi",1852),toShift,SWITCH(to_unit,"m",0,"0.1 ft",0,"0.1 ft[US]",0,"0.1 in",0,"0.1 yd",0,"1/16 in",0,"1/2 ft",0,"1/32 in",0,"1/64 in",0,"10 ft",0,"10 in",0,"10 km",0,"100 ft",0,"100 km",0,"1000 ft",0,"30 ft",0,"30 m",0,"Em",0,"Gm",0,"Mm",0,"Tm",0,"angstrom",0,"chain",0,"chain[BnA]",0,"chain[BnB]",0,"chain[Cla]",0,"chain[Ind37]",0,"chain[SeT]",0,"chain[Se]",0,"chain[US]",0,"cm",0,"dam",0,"dm",0,"fathom",0,"fm",0,"ft",0,"ft[BnA]",0,"ft[BnB]",0,"ft[Br36]",0,"ft[Br65]",0,"ft[Cla]",0,"ft[GC]",0,"ft[Ind37]",0,"ft[Ind62]",0,"ft[Ind75]",0,"ft[Ind]",0,"ft[SeT]",0,"ft[Se]",0,"ft[US]",0,"fur[US]",0,"hm",0,"in",0,"in[US]",0,"km",0,"link",0,"link[BnA]",0,"link[BnB]",0,"link[Cla]",0,"link[SeT]",0,"link[Se]",0,"link[US]",0,"m[Ger]",0,"mi",0,"mi[US]",0,"mi[nautUK]",0,"mi[naut]",0,"mil",0,"mm",0,"nm",0,"pm",0,"rod[US]",0,"um",0,"yd",0,"yd[BnA]",0,"yd[BnB]",0,"yd[Cla]",0,"yd[Ind37]",0,"yd[Ind62]",0,"yd[Ind75]",0,"yd[Ind]",0,"yd[SeT]",0,"yd[Se]",0,"yd[US]",0,"nmi",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
m metre 1m
0.1 ft tenth of foot 0.03048—
0.1 ft[US] tenth of US survey foot 0.03048006096012192—
0.1 in tenth of inch 0.00254—
0.1 yd tenth of yard 0.09144—
1/16 in sixteenth of inch 0.0015875—
1/2 ft half of Foot 0.1524—
1/32 in thirty-second of inch 0.00079375—
1/64 in sixty-fourth of inch 0.000396875—
10 ft ten foot 3.048—
10 in ten inch 0.254—
10 km 10 kilometre 10000—
100 ft hundred foot 30.48—
100 km 100 kilometre 100000—
1000 ft thousand foot 304.8—
30 ft thirty foot 9.144—
30 m thirty metres 30—
Em exametre 1000000000000000000Em
Gm gigametre 1000000000Gm
Mm megametre 1000000Mm
Tm terametre 1000000000000Tm
angstrom angstrom 1E-10ang
chain chain 20.1168—
chain[BnA] British chain [Benoit 1895 A] 20.1167824—
chain[BnB] British chain [Benoit 1895 B] 20.116782494375872—
chain[Cla] Clarke chain 20.1166195164—
chain[Ind37] Indian Chain [1937] 20.11669506—
chain[SeT] British chain [Sears 1922 truncated] 20.116756—
chain[Se] British chain [Sears 1922] 20.116765121552632—
chain[US] US survey chain 20.11684023368047—
cm centimetre 0.01cm
dam dekametre 10dam
dm decimetre 0.1dm
fathom international fathom 1.8288—
fm femtometre 1E-15fm
ft foot 0.3048ft
ft[BnA] British foot [Benoit 1895 A] 0.3047997333333333—
ft[BnB] British foot [Benoit 1895 B] 0.30479973476327077—
ft[Br36] British foot [1936] 0.3048007491—
ft[Br65] British foot [1865] 0.30480083333333335—
ft[Cla] Clarke foot 0.3047972654—
ft[GC] Gold Coast foot 0.3047997101815088—
ft[Ind37] indian foot [1937] 0.30479841—
ft[Ind62] indian foot ]1962] 0.3047996—
ft[Ind75] indian foot [1975] 0.3047995—
ft[Ind] indian foot 0.30479951024814694—
ft[SeT] British foot [Sears 1922 truncated] 0.30479933333333337—
ft[Se] British foot [Sears 1922] 0.3047994715386762—
ft[US] US survey foot 0.3048006096012192—
fur[US] furlong US survey 201.16840233680466—
hm hectometre 100hm
in inch 0.0254in
in[US] US survey inch 0.0254000508001016—
km kilometre 1000km
link link 0.201168—
link[BnA] British link [Benoit 1895 A] 0.201167824—
link[BnB] British link [Benoit 1895 B] 0.2011678249437587—
link[Cla] Clarke link 0.201166195164—
link[SeT] British link [Sears 1922 truncated] 0.20116756—
link[Se] British link [Sears 1922] 0.2011676512155263—
link[US] US survey link 0.2011684023368047—
m[Ger] German legal metre 1.0000135965—
mi mile 1609.344mi
mi[US] US survey mile 1609.3472186944373survey_mi
mi[nautUK] United Kingdom nautical mile 1853—
mi[naut] international nautical mile 1852Nmi
mil mil 0.0000254—
mm millimetre 0.001mm
nm nanometre 1E-9nm
pm picometre 1E-12pm
rod[US] rod US Survey 5.029210058420117—
um micrometre 0.000001um
yd yard 0.9144yd
yd[BnA] British yard [Benoit 1895 A] 0.9143992—
yd[BnB] British yard [Benoit 1895 B] 0.9143992042898124—
yd[Cla] Clarke yard 0.9143917962—
yd[Ind37] Indian yard [1937] 0.91439523—
yd[Ind62] Indian yard [1962] 0.9143988—
yd[Ind75] Indian yard [1975] 0.9143985—
yd[Ind] Indian yard 0.9143985307444408—
yd[SeT] British yard [Sears 1922 truncated] 0.914398—
yd[Se] British yard [Sears 1922] 0.9143984146160287—
yd[US] US survey yard 0.9144018288036576—
nmi international nautical mile 1852Nmi

Notes

The international foot, inch, yard and mile match ft, in, yd and mi. The US survey mile is survey_mi. The international nautical mile, nmi and mi[naut], is Nmi. The UK nautical mile is not. A count such as 10 km is not the code km. Angstrom is ang.

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