I am trying to compare cells between two large excell files to be sure the data in each cell exactly corresponds to the same cell in the other xls. This
works great if it is text or the value is > 0 and not null. If the cell is 0 and the corresponding cell is null, they are not identified as different.
I think this is because they are "General" format. How do I force all cells to be text?