# Converting millimeters to feet & inches

Occasional Contributor

# Converting millimeters to feet & inches

Can someone please help me with a formula?  I would like a value to be converted from mm to feet & inches.   For example, if a cell has a value of 1716mm, i would like a formula to convert that number to feet and inches, 5' 7 9/16", as well as just inches, 67 9/16".

4 Replies

# Re: Converting millimeters to feet & inches

Hi Sharlene,

Convert to feet is

`=CONVERT(1716,"mm","ft")`

similar to inches, please check the function.

Result will be in digital format, if display as you mentioned please check https://excel-formulas.blogspot.com/2009/07/display-feet-and-inches-as-5-8-12.html. To display in inches apply custom fraction format

# Re: Converting millimeters to feet & inches

How do I convert ft and inches to just inches. Basically in my excel file height is written as "5'7" (with the apostrophe), and I have to convert it to inches. How do I do this since it's not in decimals either?

# Re: Converting millimeters to feet & inches

With 5'7 in A1:

=12*LEFT(A1,FIND("'",A1)-1)+MID(A1,FIND("'",A1)+1,2)

If you have Microsoft 365 you can also use

=SUMPRODUCT(TEXTSPLIT(A1,"'")*{12,1})

# Re: Converting millimeters to feet & inches

Slightly depends on notation. Exact five feet will be 5' or 5'0 (and never 5'0") ?