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

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!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.