I need to highlight duplicate values. But value in my column is stock as text. I tried to convert it into number by using Text to columns.... but if I do that, all my cells finish by 000... Before or after, when I highlight its highlight all the data in the column
Solved by K. C. in 21 mins