G
Guest
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
For example a cell says 75.28954 and I need the cell to be 75
D
Dave R.
Use the formula =INT(75.28954) or =INT(A1)
B
Bernie Deitrick
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
=ROUND(A1,0)
INT will change 75.99 to 75, so depending on what your rounding scheme
is....
HTH,
Bernie
MS Excel MVP
G
Guest
One further question, I have a block of cell, A1:d20. How do I convert the
block quickly?
block quickly?
D
Dave R.
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.
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.
B
Bernard Liengme
In some empty columns, use the formulas you have been given
Select and Copy these cells
Select A1
20 and use Edit | Paste Special -> Values
Now you can delete the cells with the formulas
best wishes
Select and Copy these cells
Select A1
20 and use Edit | Paste Special -> ValuesNow you can delete the cells with the formulas
best wishes