Do I simply enter the formula you recommended into the formula bar in cell A1
(example) and then try entering an inches number 55 or 55" (in cell A1) and
it should convert to 4'7"?
--
Thanks for your help


"Ron Rosenfeld" wrote:

On Mon, 19 Nov 2007 18:31:03 -0800, John A
wrote:

I found your question very similar to one our school nurse has posed: When
our gym teachers measure students they report students' height in inches only
ie 61". Might their be a formula that would convert 61 inches (61") to 5' 1"?

Assuming whole inches only:

=INT(A1/12)&" ft, "&MOD(A1,12)&" inches"

or,

=INT(A1/12)*100+MOD(A1,12)

and custom format:

Format/Cells/Number/Custom Type: 0' 00\"

If you want to report to tenths of an inch, change the Custom format to
0' 00.0\"


--ron