Prev: formulas with <>
Next: Copying from one worksheet to multiple worksheets
From: Roys31 on 13 Jan 2010 12:29
Is there any way to easily format for feet and inche?
From: Bernard Liengme on 13 Jan 2010 12:47
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" <Roys31(a)discussions.microsoft.com> wrote in message
news:C0B6A829-FB44-44CD-A2DD-9EA5404A2382(a)microsoft.com...
> Is there any way to easily format for feet and inche?

From: Chip Pearson on 13 Jan 2010 14:08

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
<Roys31(a)discussions.microsoft.com> wrote:

>Is there any way to easily format for feet and inche?
 | 
Pages: 1
Prev: formulas with <>
Next: Copying from one worksheet to multiple worksheets