If I convert the contents of the cells in COL A and COL B from numbers
to strings, would Excel then be able to search the cells in COL B for
a string that matches the string in the cells in COL A?

What is the format of the formula that would work with my example?