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