how to trim a whole excel sheet?

[fun]

i want to trim the values in a excel sheet as a whole

[Corey]

Right Click the Cell and,
Format Cells - Number - Take the Decimal places away.
This will round to next whole number.

Corey....

[Norman Jones]

Hi Corey,

See David McRitchie's TrimAll page at:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall



---
Regards,
Norman


"Corey" <[email protected]> wrote in message
news:%[email protected]...
> Right Click the Cell and,
> Format Cells - Number - Take the Decimal places away.
> This will round to next whole number.
>
> Corey....
>