Thread: How can i see on excel feet and inches from decimal system?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GerryK
 
Posts: n/a
Default How can i see on excel feet and inches from decimal system?
=ROUNDDOWN(A1/12,0)&" feet "&A1-12*ROUNDDOWN(A1/12,0)&" inches"
you can replace the words with ' and "

HTH

"Sharky" wrote:

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