Excel Formula to convert from cm to inches and feet round off to two digits

Question

In the following format (0' 00"), I needed to convert a value from centimeters to inches and feet. I am using the following format for this.

=INT(CONVERT(A1,"cm","ft")) & " '" &  12*(CONVERT(A1,"cm","ft")-INT(CONVERT(A1,"cm","ft"))) & """"

The only issue is that there are several digits after the decimal point in the value of inches, even though the result is correct.

Please help me.. how can I round off the Inches part of the value to two digits after the decimal point?

Answer 1

Use the TEXT function to format, and insert a space after the '

I hope this helps you.