If I record 68.25 inches, what I would like is in separate columns is: (5)
Feet and (8) inches and 1/4 inch

"JDay" wrote:



"Niek Otten" wrote:

Can you give examples of how exactly you enter the height?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JDay" wrote in message ...
| When I measure a students height, I document that height in total inches and
| any remaining fraction of an inch. Can I in a different workbook design a
| formula that'll separate each the number of feet, then inches and then any
| remaining fraction of an inch?