News for hackers. Stuff that matters.
Re:An alarming number of scientific papers contain Excel errors by JumpCrisscross on Saturday August 27, 2016 @07:48AM (#12371945)
I don't think Excel ever destroys the underlying data. It simply layers formatting over it. One can override by specifying custom formatting, or opt out by selecting all cells and setting their format to text.
Re:An alarming number of scientific papers contain Excel errors by wongarsu on Saturday August 27, 2016 @10:05AM (#12372380)
Once the data is in the cell, changing cell formatting is a nondestructive visual layer. But while inputting data, cell formatting changes the interpretation of the input, which is destructive.

The article describes in some detail how inputting SEPT2 in a cell with default formatting displays 9/2/2016, but is stored as 42615 (which you get if you later change the cell to text formatting).

Re:An alarming number of scientific papers contain Excel errors by jpindar on Saturday August 27, 2016 @08:19AM (#12372035)
If you enter a string whose first character is a "0" and Excel decides to change it to a number, the "0" is lost.
Re:An alarming number of scientific papers contain Excel errors by ethan_g on Saturday August 27, 2016 @08:13AM (#12372013)
Commas are an exception to that. If you paste in "10,100", it will be interpreted as a number, and you lose the comma.