By default, 3854.50 will round up to 3855. If your value is calculated,
try expanding the number of decimal places. I'll bet you'll see
something like 3854.499, which displays as 3854.50.

One possible solution:

=ROUND(A1+0.005,0)

You might want to take a look here:

http://www.mcgimpsey.com/excel/pennyoff.html


In article <1e7413c501884273917b1e4ff2df9d8d@OfficeKB.com>,
"Michelle Nichols via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote:

> This may seem trivial as I am not to advanced in excel, but I need excel to
> round up at .50 (as it stands right now if I have $3854.50 when I format
> the cell to 0 decimals it rounds down to $3854) my company rounds up at
> that number. Anybody know how to change that? Thanks!