Display measurement in feet and inches

[StuartR]

I have a cell containing a measurement in meters, and I need to display this in feet and inches. I came up with this formula, which seems awfully convoluted to me. Is there an easier way to do this? (Height in meters is in $K$2)

=((100*$K$2/2.54)-MOD((100*$K$2/2.54),12))/12&" ft "&ROUND(MOD((100*$K$2/2.54),12),1)&" in"

[Rudi]

Not much of a lenth improvement, but the CONVERT() function makes it easier to read...

=INT(CONVERT($K$2,"m","in")/12)&" ft "&ROUND(MOD(CONVERT($K$2,"m","in"),12),1)&" in"

[HansV]

A variation on Rudi's formula, converting to feet for the first part:

=INT(CONVERT($K$2,"m","ft"))&" ft "&ROUND(MOD(CONVERT($K$2,"m","in"),12),1)&" in"

[Rudi]

What a dumbo oversight was that?!
TX.

[HansV]

Not dumbo at all - your formula works fine too!

[StuartR]

Now I've learned about Convert, I never knew that existed. Thank you both.