Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting inches to feet & inches.
How do I create a formula to convert inches to show feet and inches
(examples, 118.75 = 9' 10 3/4" , 85.875 = 7' 1 7/8")? |
#2
|
|||
|
|||
Check out this page of Chip Pearson's site:
http://www.cpearson.com/excel/fractional.htm tj "svech61" wrote: How do I create a formula to convert inches to show feet and inches (examples, 118.75 = 9' 10 3/4" , 85.875 = 7' 1 7/8")? |
#3
|
|||
|
|||
Hi!
There may be something more elegant but this works: =ROUNDDOWN(INT(A1)/12,0)&"'"&" "&MOD(INT(A1),12)&TEXT(A1- INT(A1),"# ??/??")&"""" Biff -----Original Message----- How do I create a formula to convert inches to show feet and inches (examples, 118.75 = 9' 10 3/4" , 85.875 = 7' 1 7/8")? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Measurement, in feet and inches, in Excel | Excel Discussion (Misc queries) | |||
format numbers into feet / inches | Excel Worksheet Functions | |||
How can I format a cell to accept feet and inches and add them | Excel Worksheet Functions |