Excel always rounds up

[StephanieD]

If I enter 2.5 into a cell, and then change the format so that there are no digits after the decimal, the number changes to a 3.

2.4 correctly rounds to 2, but shouldn't 2.5 round to 2???

I thought that even numbers were supposed to round down, and odd numbers round up when there is a 5 right after the decimal.

[mdbct]

Excel uses arithmetic rounding where .5's always wound up. The rounding you are referring is called Banker's rounding.

Access and VBA use the banker version while Excel uses arithmetic

See here as well.
Rounding in Excel

[StephanieD]

Great, thanks!

[shg]

All you'll ever want to know about rounding: http://support.microsoft.com/kb/196652