| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I format a cell in feet?
How can I format a cell so that when I enter 12.5 it shows 12'6"? I am
trying to do this so in another cell I can multiply the length by another number. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I format a cell in feet?
You can use this formula to convert the value 12'6"" to the numeric value
12.6 in another cell... =--SUBSTITUTE(SUBSTITUTE(A1,"'","."),"""","") or you can use this... SUBSTITUTE(SUBSTITUTE(A1,"'","."),"""","") directly in a calculation involving other numeric values (no double unary is required under this circumstance). You don't show any spaces between the foot-mark and the number of inches; however, if that could occur, then you would need to remove it. That can be done by adding another SUBSTITUTE function call... =--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"'","."),"""", "")," ","") -- Rick (MVP - Excel) "Ted M." <Ted wrote in message ... How can I format a cell so that when I enter 12.5 it shows 12'6"? I am trying to do this so in another cell I can multiply the length by another number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to convert decimal feet to feet inch sixteenths | Excel Discussion (Misc queries) | |||
| Format cell to show numbers as feet | Excel Discussion (Misc queries) | |||
| 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) | |||
| How can I format a cell to accept feet and inches and add them | Excel Worksheet Functions | |||
Linear Mode
