clarification request:
Using your first formula... would the entire formula including the
characters beyond the comma (,) go into the formula bar with cell A1
selected? Also, is there a space after the comma followed by
"&MOD(A1,12)&"inches"?
--
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