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 toolsoptionscalculations


--

Regards,

Peo Sjoblom


"Louis" wrote in message
...
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