Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert decimal to feet and inches
I've seen the other posts but they deal with smaller numbers or different
formats. I need to convert 188.76 inches to feet and inches. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert decimal to feet and inches
=INT(A1/12)&" ft "&TEXT(MOD(A1,12),"#.00")&" ins"
"Erik" wrote: I've seen the other posts but they deal with smaller numbers or different formats. I need to convert 188.76 inches to feet and inches. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert decimal to feet and inches
or ...
=INT(A1/12)&" ft "&ROUND(MOD(A1,12),2) &" ins" "Erik" wrote: I've seen the other posts but they deal with smaller numbers or different formats. I need to convert 188.76 inches to feet and inches. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert decimal to feet and inches
Genius! Thank you this worked great.
"Toppers" wrote: or ... =INT(A1/12)&" ft "&ROUND(MOD(A1,12),2) &" ins" "Erik" wrote: I've seen the other posts but they deal with smaller numbers or different formats. I need to convert 188.76 inches to feet and inches. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert decimal to feet and inches
I need to know if you can add the fractions in 16ths?
"Toppers" wrote: or ... =INT(A1/12)&" ft "&ROUND(MOD(A1,12),2) &" ins" "Erik" wrote: I've seen the other posts but they deal with smaller numbers or different formats. I need to convert 188.76 inches to feet and inches. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert decimal to feet and inches
Yes.
If you want the input in 16ths, just use something like 188 13/16. If you want the output in 16ths, change the formula from =INT(A1/12)&" ft "&TEXT(MOD(A1,12),"#.00")&" in" to =INT(A1/12)&" ft "&TEXT(MOD(A1,12),"# ??/16")&" in" -- David Biddulph "Erik" wrote in message ... I need to know if you can add the fractions in 16ths? "Toppers" wrote: or ... =INT(A1/12)&" ft "&ROUND(MOD(A1,12),2) &" ins" "Erik" wrote: I've seen the other posts but they deal with smaller numbers or different formats. I need to convert 188.76 inches to feet and inches. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to convert decimal feet to feet inch sixteenths | Excel Discussion (Misc queries) | |||
How can i see on excel feet and inches from decimal system? | Excel Worksheet Functions | |||
Convert feet/inches to decimal | Excel Worksheet Functions | |||
is there a macro that will convert from inches to feet and inches | Excel Discussion (Misc queries) | |||
How do i convert feet and inches to a decimal value? | Excel Worksheet Functions |