- Jun 3, 2005
when I click on a cell it shows '12345 in the formula bar but only the number in the cell. I am trying to compare to columns to see if they are equal. The result is false and I believe the apostrophe may be the reason. How can I remove this apostrophe from several thousand rows?