Text and Number format issue

[xzaqus]

Hi,

I have IDs in Column A stored as Text (data is both numbers and text).

To get unique IDs, I used an advanced filter and the results are in Column D.

Problem is that the results show duplicates. For example, 130 shows twice. One has the error message - number stored as text- on the corner, the other does not. So apparently, 130 on A3 is different than 130 in A5, A9, and A16.

I have formatted the column as Text. I have tried Selection.Value = Selection.Value after selecting column A. But, I keep getting the same results. Is there a way to fix this such that all values are formatted as text?

Here is the sample sheet with issues.

Thank you.

 

[Norie]

Which workbook are you having the problem with?

 

[xzaqus]

Which workbook are you having the problem with?

My bad. Here is the file.