title: Find Duplicates in a column with large number (as text)
body: <p>I have a SpreadSheet with a column with large number represented as text, and when I apply the duplicate operation to check ( I do not use any formula, I am using excel 2010 in-built functionality of "Conditional Formatting" -->"Highlight Cells Rule" --> "Duplicate Values") even distinct values are shown as duplicate values.</p>
  
  <p>For example:</p>
  
  <p>If I just have following values in a column of spread sheet:</p>
  
  <pre><code>26200008004000800000000000000001
  26200008004000800000000000000002
  26200008004000800000000000000003
  </code></pre>
  
  <p>It shows as all 3 values being duplicate.
  How do I fix this and check for duplicates with these large numbers in excel.</p>
  
  <p>P.S: I know excel has a 15 digit limit to precision, but is there a work around or another application to find duplicates.</p>