| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I display numbers as feet AND inches, as in x'x" ?
How do I get cells to display in feet and inches using the x'x" format? For
instance, instead of 16", display 1'4" . or, instead of 2.5', display 2'6" I've tried to write my own custom number format to no avail, since I can't figure out how to get a custom format to perform functions. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display feet inches and fraction | Excel Discussion (Misc queries) | |||
| convert column with inches to 2 columns "feet" and "inches" | Excel Discussion (Misc queries) | |||
| Is it possible to display feet and inches in one cell ? | Excel Worksheet Functions | |||
| Convert inches & display as Feet Inches and Fractions -- BUG FREE | Excel Worksheet Functions | |||
| display feet and inches | Excel Discussion (Misc queries) | |||
Threaded Mode
