Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set a cell format for Feet and Inches? i.e. 3'-10 1/2"
How do I set a format in cells to display feet and inches as follows?
3'-10 1/2" or 3-10 1/2 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set a cell format for Feet and Inches? i.e. 3'-10 1/2"
Let's say that cell A1 contains a length in feet: 12.1 then in cell B1 put:
=INT(A1)&"' "&INT(12*(A1-INT(A1)))&""" "&TEXT(MOD(12*(A1-INT(A1)),1),"##/##") which will display as 12" 1" 1/5 If you need the reverse, put the feet and inches into separate cells to make the math easier -- Gary''s Student "JB" wrote: How do I set a format in cells to display feet and inches as follows? 3'-10 1/2" or 3-10 1/2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenating from a different cell within the same row | Excel Discussion (Misc queries) | |||
Cell format inch | Setting up and Configuration of Excel | |||
Special format for feet - inches in a cell | Excel Discussion (Misc queries) | |||
How can I show Feet and inches in a Excel cell? | Excel Discussion (Misc queries) | |||
How can I format a cell to accept feet and inches and add them | Excel Worksheet Functions |