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

0 votes

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?

Oct 15, 2022 in Others by Kithuzzz
• 38,010 points
707 views

1 answer to this question.

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

I hope this helps you.
answered Oct 15, 2022 by narikkadan
• 63,700 points

Related Questions In Others

0 votes
0 answers

MS EXCEL: Convert (Height) Decimal Feet & Inches to Inches Only

Using MS Excel (2010), I would like ...READ MORE

Feb 10, 2022 in Others by Edureka
• 13,670 points
430 views
0 votes
0 answers

Converting feet & inches (e.g., "5 ft 1 in") to decimal feet using VBA or Excel

I have a database with a few ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,010 points
462 views
0 votes
2 answers
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
2,121 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,635 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,670 points
797 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
2,825 views
0 votes
1 answer

Excel formula to convert number to both feet and inches

If you want the answer to be ...READ MORE

answered Jan 5, 2023 in Others by narikkadan
• 63,700 points
584 views
0 votes
1 answer

How can I convert excel to PDF by Libreoffice and keep all format from excel file?

"Times New Roman" typeface does not have ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,700 points
1,417 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP