Can the ROUND function be active for ALL CELLS in a
workbook? - or do you have to enter it each time you want
something to be rounded in a cell or with another function
in a cell?

If you can do it - HOW would you do it?

Thanks

Hi
one way:
goto 'Tools - Options - View' and check 'Fixed decimals'. Note: This
will change your current data

--
Regards
Frank Kabel
Frankfurt, Germany


Myra Maxon wrote:
> Can the ROUND function be active for ALL CELLS in a
> workbook? - or do you have to enter it each time you want
> something to be rounded in a cell or with another function
> in a cell?
>
> If you can do it - HOW would you do it?
>
> Thanks

If your workbook is a financial one, you might consider

Tools>options>Calculation, and check Precision as displayed

I use that very often; it is a natural way of handling data in a commercial
environment. Read HELP for all possible effects

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Myra Maxon" <(E-Mail Removed)> wrote in message
news:004f01c423ed$9e4e00f0$(E-Mail Removed)...
> Can the ROUND function be active for ALL CELLS in a
> workbook? - or do you have to enter it each time you want
> something to be rounded in a cell or with another function
> in a cell?
>
> If you can do it - HOW would you do it?
>
> Thanks