converting to Integers

[bmordhorst]

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

[Dave R.]

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



"bmordhorst" <[email protected]> wrote in message
news:[email protected]...
> 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

[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

"bmordhorst" <[email protected]> wrote in message
news:[email protected]...
> 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

[bmordhorst]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

[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.



"bmordhorst" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> >
> >
> >

[Bernard Liengme]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>>
>>
>>