To stop the rounding of numbers
 

I'm trying to setup a golf handicaping worksheet and I'm stuck trying to
figure out how to display a number that has not been rounded. After I have
done my formulas to arrive at a number that has 4 numbers past the decimal
point I'm supposed to get rid of all the numbers accept the first one past
the decimal point without rounding. I'm looking to hide the column with the 4
places and display a column with the unrounded number. This cant be as
difficult as it seems.
Thanks Frank

To stop the rounding of numbers
 

=TRUNC(A1,1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"franke" wrote in message
...
I'm trying to setup a golf handicaping worksheet and I'm stuck trying to
figure out how to display a number that has not been rounded. After I have
done my formulas to arrive at a number that has 4 numbers past the decimal
point I'm supposed to get rid of all the numbers accept the first one past
the decimal point without rounding. I'm looking to hide the column with
the 4
places and display a column with the unrounded number. This cant be as
difficult as it seems.
Thanks Frank