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 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?
4 Replies
- 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?
