| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i convert feet and inches to a decimal value?
I have an assignment that shows me this equation but it doesnt seem to
work, =LEFT(A1,FIND("",A1)-1)+((MID(A1,FIND("",A1)+1,LEN(A1)-FIND("",A1)-1))/12) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format number in feet and inches | Excel Discussion (Misc queries) | |||
| How can I show Feet and inches in a Excel cell? | Excel Discussion (Misc queries) | |||
| 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 | |||
Threaded Mode
