| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMAT FOR FEET AN DINCHES
Is there any way to easily format for feet and inche?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
FORMAT FOR FEET AN DINCHES
1) Suppose A1 contains a value such as 63 to represent 63 inches, then the
formula =INT(A1/12) & " ft. " & MOD(A1,12) & " in." will display 5 ft 3 in. But this is TEXT and you can do not math on it 2) I find it better to enter, for example, 5 3/12 and to format the range with custom format # ?/12 You can do all the math you need on such cells best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Roys31" wrote in message ... Is there any way to easily format for feet and inche? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
FORMAT FOR FEET AN DINCHES
See http://www.cpearson.com/Excel/FractionalArithmetic.aspx Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Wed, 13 Jan 2010 09:29:01 -0800, Roys31 wrote: Is there any way to easily format for feet and inche? |
| 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) | |||
| decimal feet to feet-inch-sixteenths conversion | 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) | |||
| format number in feet and inches | Excel Discussion (Misc queries) | |||
| format numbers into feet / inches | Excel Worksheet Functions | |||
Linear Mode
