I wanted to convert a value from centimeters to Inches and Feet. in the following format (0' 00'') and I am using the following forumla for this
=INT(CONVERT(A1,"cm","ft")) & " '" & 12*(CONVERT(A1,"cm","ft")-INT(CONVERT(A1,"cm","ft"))) & """"
The answer is accurate but the only Problem is The value of Inches has a lot of digits after decimal points..
Please help me how to round off in excel the Inches part of the value to two digits after decimal point?
Please help me how can I improvise this formula Thanks
Solved by C. F. in 23 mins