If a cell contains only digits, and assumes it is a number even though it cannot handle it. "000005234523453249587234985" is simply ruined.
A quick note on this: If you input '000005234523453249587234985 into the cell it will store as a string and maintain the leading 0's. This is a pain for working with, but does make the numbers display nicely.
I recently found out about this because a user was inputting numbers like this and breaking a formula later on the page 🙃
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
A quick note on this: If you input
'000005234523453249587234985into the cell it will store as a string and maintain the leading 0's. This is a pain for working with, but does make the numbers display nicely.I recently found out about this because a user was inputting numbers like this and breaking a formula later on the page 🙃