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 558 views

## 1 answer to this question.

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

I hope this helps you.
• 63,420 points

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

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

## 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

## How to build a custom column formula in Power query that will retrieve Image and load it to Excel to display that image from the specified column

Make sure ignore privacy is selected in ...READ MORE

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

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

## Convert Rows to Columns with values in Excel using custom format

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

## IF - ELSE IF - ELSE Structure in Excel

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