Let user control decimals; do not automatically modify input values
Excel will change the number of decimals displayed when a user inputs numbers. For scientific and engineering applications, this has huge impacts on our data.
The input 2.00 is very different than 2, because fewer decimals displayed implies that we have not measured precisely or that we have a large amount of error in the number.
This applies across Excel. For example, I recently made a chart where the data was measured to three significant figures (ie my inputs were 5.24, 6.00, 6.25) but the line graph on the y-axis shows the markers "5.2, 5.6, 6, 6.4." This makes my data look sloppy.
Please, please, please, stop erasing/changing significant figures (decimals) when we input numbers. And please display the number of decimals in data on graphs, in further calculations, and in all other applications.
There is a reason someone chooses to go to the effort of typing "2.000" instead of just "2" and if this causes a problem for some other uses of Excel, there could be an option to disable it.
I have an issue where Excel is automatically adding decimals to whole numbers, so 300 becomes 3.00.
This automatic formatting based on Microsofts assumption of what a user wants to do is a deal breaker and seriously impacts productivity. It needs to be clearly controllable rather than unexpected behavior.