I am trying to convert Inches to the nearest foot in a column

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

regards
FSt1

"Mario454" wrote:

I am trying to convert Inches to the nearest foot in a column

If the inches are entered as integers:

A1 = 38

=ROUND(A1/12,0)

--
Biff
Microsoft Excel MVP


"Mario454" wrote in message
...
I am trying to convert Inches to the nearest foot in a column