Forum Discussion
Excel modfying my numbers
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 t...
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.
JKPieterse any idea how to solve the conditional formatting issue then so it doesn't identify all cells as if they had the same value?
Detlef_Lewin It is a good workaround, thanks!
