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 can I round off the Inches part of the value to two digits after decimal point? Please help me how can I improvise this formula Thanks Saram.
Solved by C. F. in 23 mins