| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display feet and inches
Is there any way in excel to display feet and inches? I can get decimal feet
and even fractional feet ie. 3 1/3. Is there any way to multiply the fraction portion of that by 12 to get it to spit out 4? Even if it ends up in two differnet cells, I can get another cell to read 3 and the next cell to read 4, and squash them together to look like 3'-4". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| feet and inches | Excel Worksheet Functions | |||
| Special format for feet - inches in a cell | Excel Discussion (Misc queries) | |||
| is there a macro that will convert from inches to feet and inches | Excel Discussion (Misc queries) | |||
| Calculating the Area of objects in Feet and Inches | Excel Discussion (Misc queries) | |||
| Converting inches to feet & inches. | Excel Worksheet Functions | |||
Threaded Mode
