http://www.cpearson.com/excel/fractional.htm
Chip has some info on DOLLARDE and DOLLARFR you may find
useful for this.
HTH
-----Original Message-----
Thanks GerryK, ill use the rounddown function.
"GerryK" wrote:
Not without VBA
Try this:
http://www.mrexcel.com/tip012.shtml
-----Original Message-----
So theres no way to format data for particular cells
as
feet,inches persay?
IE cell A1 is 12"4" and cell B1 is 12' 8" and
formula
for cell c1 would be
Sum(a1,b2).
"GerryK" wrote:
If you convert your data to inches you can use:
ROUNDDOWN(A1/12,0)&" feet "&A1-12*ROUNDDOWN(A1/12,0)
&"
inches"
Try putting inches (your result) in A1 for this
example.
-----Original Message-----
How do you add or subtract feet & inches in
formulas
IE
12' 4" + 12' 8"...
--
Wayne Hof
.
.
.