hi
with inches in column A, you could use a fomula like this...
=A2*(1/12)
then format the formula cell to zero decimals for roundoff.
or
=round(A2*(1/12),0) and not have to format the cell.
if you have the analysis tool pack, you could use then use the DOLLARDE and
DOLLARFR functions.
see this site on how to use them http://www.cpearson.com/excel/fractional.htm
