Rounding Issues

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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