In cell A1 I have the following value: 108820751000620
In cell A2 I have the following value: 108820751000620.004
They are in text format.
In cell B1 I have the following formula: "=COUNTIF(A:A,A1)"
In cell B2 I have the following formula: "=COUNTIF(A:A,A2)"
There is nothing else on the entire spreadsheet.
The result of both of these formulas is coming up as 2, so Excel must be regarding the two values in Col A as the same thing, but they are clearly not. What could possibly be causing this?
When I try to change them from text format to general format using the Text To Columns method, the ".004" portion of cell A2 disappears and then the two cells really do equal each other. This is baffling to me and I don't think Excel was behaving this way before. I had been fiddling with the "Precision As Displayed" and "maximum Change" commands from the Options menu earlier, but I have since turned off Precisions As Displayed and set the Maximum Change to 0. Perhaps that's what's causing this but I don't know what to do to fix. I just want the Countif formulas to work properly and recognize that the values in cells A1 and A2 are different/unique.
Any ideas? I am using Excel 2003.
In cell A2 I have the following value: 108820751000620.004
They are in text format.
In cell B1 I have the following formula: "=COUNTIF(A:A,A1)"
In cell B2 I have the following formula: "=COUNTIF(A:A,A2)"
There is nothing else on the entire spreadsheet.
The result of both of these formulas is coming up as 2, so Excel must be regarding the two values in Col A as the same thing, but they are clearly not. What could possibly be causing this?
When I try to change them from text format to general format using the Text To Columns method, the ".004" portion of cell A2 disappears and then the two cells really do equal each other. This is baffling to me and I don't think Excel was behaving this way before. I had been fiddling with the "Precision As Displayed" and "maximum Change" commands from the Options menu earlier, but I have since turned off Precisions As Displayed and set the Maximum Change to 0. Perhaps that's what's causing this but I don't know what to do to fix. I just want the Countif formulas to work properly and recognize that the values in cells A1 and A2 are different/unique.
Any ideas? I am using Excel 2003.