HELP! Convert decimal value to display feet & inches

I think the only way to do this is to have two cells/columns. One column where you can enter your decimal feet numbers, and a helper column that converts the decimal feet number into the desired text string. Something like

1) INT(value) function to get the integer feet part of the number/text string)
2) CONVERT(MOD(value,1),"ft","in") to get the decimal inches portion of the value.
3) TEXT(CONVERT(...),"## ##/##") to display the decimal inches as a mixed number fraction.
4) Concatenate those together with appropriate spaces and such. =INT(...)&"'-"&TEXT(...)&CHAR(34)

Because you want to be able to use the original decimal feet number in other calculations, you will want to keep the number value separate from the text representation.

Would such a helper cell/column be an acceptable solution?

I can think of no way using number formatting that will display a decimal feet number as "feet -- inches -- fraction of an inch." When I first started using spreadsheets, this help file was one of my most frequently referred to as I learned the different number format codes: https://support.microsoft.com/en-us/...7-9c9354dd99f5

You might review that help file and see if there is a number format code that I have overlooked. Unless we can find number formatting to do the job, I see no way to do this without some kind of helper column.

Here is an example of a solution that is very similar to Fluff's proposal:

Please enter the number in B2 and try in C2

Formula:

Please Login or Register  to view this content.