prevent duplication

B

Ben Blair

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
 
P

PC

This doesn't answer your question but I do not believe that Excel is storing
16 digit numbers. AFAIK it can only store 15 digit numbers. Anything more
is truncated. If you look in the formula bar you will see that last digit
appears as a 0

You will need to enter these numbers as text (proceeded by a ' )

PC
 
Top