Drop decimal and don't round

[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

 

[Chip Pearson]

Alex,

Use the TRUNC function. E.g.,

=TRUNC(A1,0)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Paul]

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

For a number in A1 use
=TRUNC(A1)
rather than
=ROUND(A1)

 

[Dave Peterson]

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.

 

[Mark Adams]

Alternatively, display the INTEGER value only,

=INT(A1) etc

Mark