Hi Michelle

formatting a cell doesn't actually round numbers it just supresses the
display of the decimals (to test this, format your cell to show 3854.50 as
3854 and then in another cell multiply this formatted number by 100)

to round a number, use the round function
e.g.
=ROUND(A1,0)
to round to no decimal places
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Michelle Nichols via OfficeKB.com" wrote in
message ...
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!