I have a column of number, with two decimal points.
For example, lets use the following three numbers from a column that is 1600 rows, all with two digit decimal points.
2051.04
2034.98
2015.75
those are in a1 to a3
in b2, I set up the formula =a2-a1, where I get the value, -16.06, that is subtracted. When I then copy that cell and use paste special, values, into the same cell, so that I can just see the numerical value in that cell without a formula, I get -16.0599999999999 when I click on the cell to see the value.
How can I get that to just be -16.06? I started with two decimal points, and I would like the cell value to be two decimal points. thanks
Bookmarks