Drop decimal and don't round

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi folks,

In Excel XP, I have a colume of numbers with decimals... example:

151.65
144.34
433.23
144.90

I want to drop the decimals, but NOT round. Excel wants to round the
151 to 152 and 144 to 145 (for example). I simply want to make the
colume a whole number but not round up if decimal is over .5.

Is this possible?? Is this simple??

Thanks,

Alex
 
Alex said:
Hi folks,

In Excel XP, I have a colume of numbers with decimals... example:

151.65
144.34
433.23
144.90

I want to drop the decimals, but NOT round. Excel wants to round the
151 to 152 and 144 to 145 (for example). I simply want to make the
colume a whole number but not round up if decimal is over .5.

Is this possible?? Is this simple??

Thanks,

Alex
Click to expand...

For a number in A1 use
=TRUNC(A1)
rather than
=ROUND(A1)
 
There's another function =int() that works the same way as =trunc(), but behaves
differently with negative values.

You may want to look at help to see the difference if you have negatives.
 
Back
Top