prevent duplication

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Preventing Duplicate Cells 2
Access Auto Matching Duplicates? 0
Excel Subtotal without calculate duplicate lines 4
Complicated Formula Problem 10
Preventing Duplicates 11
Problem not counting duplicates 1
Counting number of items excluding duplicates. 1
Find duplicate entries that have trailing digit that may change. 1

Back
Top