Available number format codes: https://support.office.com/en-us/art...2-09fab54be7f4
I am not aware of a number format that will display a value in inches as feet inches.
From a fractional feet number, I have used a format code like 0 0/12 to display feet and inches (as a fraction of a foot), but that still requires you to convert your inches to feet, and I suspect many would be less than satistified with the fraction/12.
I would expect that something like davesexcel's text output is going to be the easiest way to get exactly what you are requesting.
Bookmarks