Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to convert from centimeters to feet and inches (with desired formatting), e.g. 175 cm > 5'9"?

578 0
Showing results for 
Search instead for 
Did you mean: 

I have a field that contains people’s heights in centimeters. I’d like to create an additional field that converts those heights to feet and inches, specifically using the format #’#".

The conversion part is easy; to get from centimeters to inches, you simply divide by 2.54, after which I’d want to round to the nearest inch. It’s the formatting part that I’m hung up on.

For example, 175 centimeters converts to 69 inches, rounded to the nearest inch. But how do I force 69 inches to display instead as 5’9"?

Thanks in advance for any help here!

0 Replies 0