| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
feet and inches
Can Excel display fractions for distances (measured in inches) with the
lowest common denominator? For example... 5 8/16 (5.5) displayed as 5 1/2 3 10/16 (3.625) displayed as 3 5/8 1 13/16 (1.8125) displayed as 1 13/16 I'm amazed I haven't been able to find an answer to this on Google. You would think with the construction industry being so large that this would be a piece of cake. I've played around with Custom Number Format but haven't found a solution. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| feet inches multiply with feet inches | About this forum | |||
| convert decimal inches into feet and inches | Excel Discussion (Misc queries) | |||
| Convert inches & display as Feet Inches and Fractions -- BUG FREE | Excel Worksheet Functions | |||
| Converting from feet, inches and fractions to inches and decimal p | Setting up and Configuration of Excel | |||
| is there a macro that will convert from inches to feet and inches | Excel Discussion (Misc queries) | |||
![Dave B[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
