Weird Number Change

[EStein9077]

Can someone explain this to me?

Format a cell to number with zero decimal places.  Paste 8299400461135159 into the cell.  Hit enter.

The number changes to 8299400461135150.

I know I can format the cell as text to show it correctly nut I want to know why it changes when it is formatted as a number.

Any ideas?

[#2 · Accepted solution]

@EStein9077 

https://superuser.com/questions/1041458/what-is-largest-value-number-that-i-can-store-in-an-excel-vb...

A Google search turned that up. 15 digits is the max. above that it starts doing what you're witnessing. Now, "WHY THAT limit...?" is another question, of course.

[#3]

WHY THAT limit?

Just kidding. Thanks for the info. Makes as much sense as Excel not being able to sort IP addresses correctly.