Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi;
Is there a way to get a custom format to display a decimal as feet and inches? For example 13.5 ft as 13'-6". The closest I can get is 0"'-"##/12'' gives 13'-6/12''. I would like to be able to have it display as 13'-6'' without having to use formulas and without having the divisor visible for inches. Thanks. Adam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change decimal to feet and inches | Excel Discussion (Misc queries) | |||
How do I convert decimal to feet and inches | Excel Worksheet Functions | |||
Converting from feet, inches and fractions to inches and decimal p | Setting up and Configuration of Excel | |||
Convert feet/inches to decimal | Excel Worksheet Functions | |||
How do i convert feet and inches to a decimal value? | Excel Worksheet Functions |