Convert mm to ft-in

[webermis]

I am trying to convert a chart with millimeters (mm) to ft-in format. Any
method will be appreciated.

webermis

 

[Bob Phillips]

=INT(convert(A22/100,"m","ft"))&"ft,"&ROUND(MOD(convert(A22/100,"m","in"),36
),0)&"in"

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[webermis]

I appreciate your help.

webermis

=INT(convert(A22/100,"m","ft"))&"ft,"&ROUND(MOD(convert(A22/100,"m","in"),36
),0)&"in"

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dana DeLouis]

... to convert...millimeters (mm) to ft-...

Hi. I might be wrong, but with the following...

=CONVERT(55/100,"m","ft")
1.804461942

Gives a different answer than..
=CONVERT(55,"mm","ft")
0.180446194

I thought it was /100 also, but I think it's /1000. :>0