Excel modfying my numbers

[Rodolfo2245]

Hi,

When working on excel I am adding some numbers under a column but excel keeps giving me headaches.

Let's use number 89014103272207385549

If I use a general format it changes the number to 89014103272207300000 and shows as 8.90141E+19.

If I use a number format it changes it to 89014103272207300000.

If I use a text format the numbers are kept as 89014103272207385549 but Conditional Formatting recognizes all values on the column as the same.

Any ideas on what's happening or why is excel behaving like this?

[#2]

Excel can only handle numbers with a maximum of 15 digits. If you enter more Excel converts the number to scientific format (the E+19 you stated), unless you preset the cell to a Number format. In that case Excel takes your first 15 digits and appends zeroes for the remainder of he number. There is no way to prevent this I'm afraid, as that is a hard limit.

[#3]

@Jan Karel Pieterse any idea how to solve the conditional formatting issue then so it doesn't identify all cells as if they had the same value?

[#4]

@Rodolfo2245 

Take a look at this:

https://newtonexcelbach.com/2017/12/22/the-countif-bug-and-how-to-avoid-it/

[#5]

@Detlef Lewin It is a good workaround, thanks!