I asked a couple days ago about preventing duplication in a long list. While
all the answers were valid and helpful for short data, I have a lot of long
data (16 digits each). Excel is rounding the numbers into 3E-3 for example,
so that accounts with a different last digit are being counted as duplicates.
For example, it works great for 1122334455667788 and 2233445566778899, but
not so great for 1122334455667788 and 1122334455667789. Is there a way to
either set Excel to read the full number or to get a more precise duplication
prevention? Thanks