It's not rounded, it's formatted to show 2 decimals, if you want to round
you can use a help column

=ROUND(A2,2)

copy down/across as long as needed, copy the help range and paste special as
values over the old range
or use precision as displayed under tools>options>calculations


--

Regards,

Peo Sjoblom


"Louis" <Louis@discussions.microsoft.com> wrote in message
news:4E83189F-F5BB-4052-B6C4-55AB7368A587@microsoft.com...
> I know this is easy but cannot get it for the life of me. I have an
entire
> column of prices that are rounded correctly, with two decimal places, but
the
> source data still says 4.345, not 4.35 like I need it to (I am uploading a
> database into Quickbooks). So when I go to import the data it says it is
in
> an incorrect number format, thinking the number I am trying to upload is
not
> the rounded number. I have tried the paste special feature but it doesn't
> seem to work with removing the rounding format.
> Thanks,
> --
> Louis