I am working on a project where I compare values from one worksheet to another. When I look at the cell (for example A1), the value in the cell shows 8.999. When I look at the cell (for example A1), in the second worksheet, it also shows 8.999. My code highlights the cell if there is no match. The code highlights these cells as not matching. When I look at the top of the ribbon, the cell shows not as 8.999 in the first worksheet, but 8.999888888888. How can I make these two cells as equal, so the cells will not show highlighted as not matching. Hope this doesn't sound confusing.
Thanks in advance.
Jim