How to format cells to show ' and " for feet and inches

[feetandinches]

I would like to enter 12 5 in a cell and have them return 12'5" as a result. I don't know how to enter the formula in the format cells dialog box. Any help would be appreciated.

 

[RonB1111]

If you enter 12 5 in cell A1, this formula entered in another cell (say B1) will display it a 12'5"

=SUBSTITUTE(A1," ","'")&"''"

Note: the end of the formula is a double quote then 2 single quotes then a double quote (ie: " ' ' " )

I don't believe there's a way to format your input cell to change the display of a text entry 12 5 to 12'5". It is possible to use cell formatting to display decimals as fractions, but it doesn't sound like that's what you're after.