Hghlight duplicate Cells in a row , but cells contain 22 digits or more

[Plokimu77]

Good morning,

I have numbers for part orders that are sometimes longer than 22 digits in a cell
for example:
92419901082947182020011750

I currently stored the numbers as text in the cell, because if I don't then the numbers become this:
9.24199010829471E+25

My problem is that when I Condition the row to highlight duplicates,
and I sort the row, I noticed that some of the numbers are not duplicates.

Is it because they are stored as text?
Or is it because excel can only read a certain amount of characters in a cell?

Does any have an idea of a way I can work around this?


Thank you.

 

[DRSteele]

Store the numbers as numbers. If you format the cell that contains the uber-number as Number with zero decimal places and no thousands separator it will appear as you want it.

 

[JoeMo]

Store the numbers as numbers. If you format the cell that contains the uber-number as Number with zero decimal places and no thousands separator it will appear as you want it.

That's not so. Excel has a 15-digit precision for numbers so a number that is longer will be truncated after the 15th digit. Example: 92419901082947182020011750 if formatted as a number with zero decimal places will appear as
92419901082947100000000000.

How are you storing the numbers as text?

 

[DRSteele]

I stand corrected. I did not know about 15-digit precision.

 

[Plokimu77]

Yes, I am storing the numbers as text.

Thank you for the 15 digit insight.

Is there a way around it?

Thank you.

 

[JoeMo]

Yes, I am storing the numbers as text.

Thank you for the 15 digit insight.

Is there a way around it?

Thank you.

You didn't answer the question as to exactly how you are storing the numbers as text. Are they imported as text or are you formatting the cells as text first, then pasting the numbers or ....?

I'm not sure I understand what "it" is, can you elaborate and provide some sample data to illustrate what problem you want to solve?