Forum Discussion
Weird. Duplicated values highlighted in Excel, but they are clearly not duplicates!
Thank you, but my Excel shows no duplicates in your file
I don't know what's the reason, sorry. By the way, some cells in above range have General format, some hh:mm. Is that intentionally?
i also experience the same problem, i deal with barcodes and "case ids" at my work and case ids beginning with "001" always return to me as duplicate values, and in my current workbook even appear to be sorted as such when using advance search
| 00112000020002097792 |
| 00112000020002097914 |
| 00112000020002097907 |
| 00112000020002097891 |
| 00112000020002097747 |
| 00112000020002097808 |
| 00112000020002097815 |
| 00112000020002097846 |
| 00112000020002097884 |
| 00112000020002097761 |
| 00112000020002097822 |
| 00112000020002097785 |
| 00112000020002097938 |
| 00112000020002097723 |
| 00112000020002097778 |
| 00112000020002097921 |
| 00112000020002097013 |
I have the same problem as you. this problem is because excel can only distinguish duplicates with content in cells no more than 15 characters. but I don't know how to extend the character limit
That's bit different issue. Comparing texts which looks like numbers conditional formatting converts them to numbers and compares the latest. Comparing the numbers all what after first 15 digits is ignored. Same behaviour has COUNTIF().
To prevent conversion we may use such trick:
