Quit changing my data
Quit changing my data. If I enter 10.00 into a cell that is what needs to stay there. Formatting can change the display of the data but you must stop changing what I enter.
This really matters to those of us in technical fields. I (and my colleagues) know the difference between 10 and 10.00, and it matters to us.
Yeah, workarounds exist. Entering into cells formatted as text which can then be examined formulaically for value and separately for precision from the user's simple single input is another way one might approach it.
But it's so basic to many of the usage silos for Excel, that it sure would be nice to have it natively, especially if Excel chose a standard and enforced it programmatically.
Kenneth Barber commented
Workaround: enter the precision in a separate column to preserve the precision information.
Actually, it DID change the "data value" both in its purpose as data and therefore its utility and in the sense of it's now garbage.
Perhaps there could be a "Precision" number format in which one enters "10.00" and its representation stays either that directly, or perhaps, by analogy to scientific notation in Excel, could be represented as "10P+2" (or no "+" as it is not truly needed except for readability perhaps). It would keep the original precision stored and available to use too so one could utilize the precision directly instead of indirectly by deriving it from the store value.
That precision is critical to the calculations (i.e.: the data analysis that is the basic purpose of Excel) in which the entries are used. Seems like it would be so simple to add in as well.
And the idea that Excel has no internal facility for doing such... isn't the very purpose of this site to suggest things that Excel could have added to its "internal facilities"?
A.C. WILSON commented
The data value was NOT changed. Only Mark Ballard's desired display format was changed.
Excel has no internal facility for also storing a declared precision of a value alongside that value. (Does any statistical software, or programming language, have such a facility? I myself do not know. If such a facility did exist, one might want it to also handle precisions more complicated than simple integer powers of ten.)
If it maters that much, you should engage in learning about your tools:
Mark Ballard commented
I have been asking them nicely for over 10 years.
And I submit you are wrong, Brian Hughes, they have changed the data. Enter 10.00 and leave the cell. Come back, the cell holds 10. That is DIFFERENT, and not what I entered. This matters but commenter like yourself don't appear to understand. Please don't comment on items your don't understand. This really does matter in fields of science - it is not just formatting.
Brian Hughes commented
If you were to ask nicely, you could ask them could they provide the ability to infer formatting from input so that 10.00 would infer you want that cell to be formatted with 2 decimals. Barking at them to quit changing your data (they havent.. by the way, just it's signified accuracy) should get your idea binned.