converting to Integers
 

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

Use the formula =INT(75.28954) or =INT(A1)



"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

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

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

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

In some empty columns, use the formulas you have been given
Select and Copy these cells
Select A1:D20 and use Edit | Paste Special - Values
Now you can delete the cells with the formulas

best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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