I am trying to compare two columns of data with the match function. The
values are the same, but it seems as if the formatting is different because
the match doesn't find the matched data. I have chosen "format Cells" and
made sure both are a text format, but it doesn't seem to affect the format.
When doing the match, the first column displays as "1066", the second as
1066. Can someone help?