Comment by aqfamnzc

It blows my mind that the behavior in spreadsheet software is not what I would expect:

* NEVER modify the text I type into a cell.

* Parse, interpret, format the cell according to the "data type" that's detected or chosen by the user

* In the grid, display the data according to the interpretation above

* In the formula textbox, show me exactly what I typed in, unmodified.