Is there a way to ensure the COUNTIF function takes these cell values as string parameters without doing an implicit cast?

有办法确保COUNTIF函数将这些单元格的值作为字符串参数不做隐式转换？

It also doesn't seem to matter what format my hex column is - the COUNTIF function always interprets these values as Numbers and therefore they appear as duplicates.

它也似乎没有什么格式我六柱- COUNTIF函数总是解释这些值数，因此他们出现重复。