Try this:

<Tools <Options <Calculations tab,
And *check* "Precision As Displayed".

Check first to make sure that this doesn't hurt any other calculations in
the rest of the WB.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike W" wrote in message
...
Actually what I am looking for is for the detail of the cell to be rounded
as
well. For example:

a1 = 12.356487

Visually it shows 12

I want to be able to have the detail of the cell equal to 12. So that
when
I am using this cell in a calculation it views it as a whole number. The
only way I kow of is to retype the number as 12 or use the round function
but
I am dealing with 100's of cells. Thanks.

"CLR" wrote:

Highlight the cells, then right-click FormatCells NumberTab Number

select zero decimal places ok

Vaya con Dios,
Chuck, CABGx3



"Mike W" wrote:

How can I Round a large amount of #s w/o typing round formula in each
cell

Ex: 39.548759631 to 40