re: What’s the most under-appreciated software? VIEW POST

re: Hard disagree. It's over appreciated. It does not handle large volumes of data. I cannot get it to process a simple 50MiB CSV file on my desktop ...

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 🙃

code of conduct - report abuse