Thread: How can i see on excel feet and inches from decimal system?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
 
Posts: n/a
Default How can i see on excel feet and inches from decimal system?
or
=INT(C10)&"'"&ROUND(-(INT(C10)-C10)*12,0)&""""

--
Don Guillett
SalesAid Software

"Sharky" wrote in message
...
I need to see feet and inches on the screen, how can i do it

for example, 7.8333333 i need to see it like 7'10"
how can i do it?


Reply With QuoteReply With Quote