| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I show Feet and inches in a Excel cell?
How can I show Feet and inches in a Excel cell?
I'd like to calculate Feet and inches in a Excel sheet |
|
#2
|
|||
|
|||
|
Excel is metric like all sensible people or things <bg, but I would put feet
and inches in separate but adjacent cells, then you have to convert them to decimale and do the calculation and then convert them back again http://www.mvps.org/dmcritchie/excel/fractex1.htm Regards, Peo Sjoblom "Magama13" wrote: How can I show Feet and inches in a Excel cell? I'd like to calculate Feet and inches in a Excel sheet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate formulas with feet & inches | Excel Worksheet Functions | |||
| Need formulas for adding feet, inches & fraction in one cell | Excel Worksheet Functions | |||
| Measurement, in feet and inches, in Excel | Excel Discussion (Misc queries) | |||
| Converting inches to feet & inches. | Excel Worksheet Functions | |||
| How can I format a cell to accept feet and inches and add them | Excel Worksheet Functions | |||
Linear Mode
