in another column =round(a1,2) that will actually round it, then copy/paste
values to get the number

"Mark246" wrote:

I have a bunch of numbers, created by some pretty tricky calculations.
The end result is ($2.456789) dollars and cents.
It is Displayed as just $2.46, but when I use that in a calculation,
it's 2.456789.
How can I force the info in the cell to be just 2.46 ?
I've tried Copy / Paste special / Values... doesn't work.

Thanks, in advance.

Mark246.