| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to format feet/inches (ft'in")
Can I (or How can I) format cells so that I can input my information in feet
and inches? Maybe something like: 5'3" Everything would be in whole inch increments, so I don't need to bother with fractions. My information is coming to me in feet and inches, and it's a real pain to have to get it all into decimal feet so I can use it. I need a format - not a formula. Can this be done? How? TIA! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set a cell format for Feet and Inches? i.e. 3'-10 1/2" | Excel Discussion (Misc queries) | |||
| Special format for feet - inches in a cell | Excel Discussion (Misc queries) | |||
| format number in feet and inches | Excel Discussion (Misc queries) | |||
| format numbers into feet / inches | Excel Worksheet Functions | |||
| How can I format a cell to accept feet and inches and add them | Excel Worksheet Functions | |||
Threaded Mode
