View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Seperating Feet, inches and fractions

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?