The quickest way would require VBA, but it only takes about 10 seconds to
enter that formula, say in E1, copy it down through H20, then copy E1:H20
and paste special as values over the original range.

If you're going to be doing this very frequently maybe a VBA solution would
be the most efficient.



"bmordhorst" wrote in message
...
One further question, I have a block of cell, A1:d20. How do I convert
the
block quickly?

"Bernie Deitrick" wrote:

Or, use

=ROUND(A1,0)

INT will change 75.99 to 75, so depending on what your rounding scheme
is....

HTH,
Bernie
MS Excel MVP

"bmordhorst" wrote in message
...
I need to quickly convert a block of cells to integers.
For example a cell says 75.28954 and I need the cell to be 75