The value of the cell is what I typed in. How that is displayed is determined at render time or whatever, based on the data type.

This is already kind of the case. If you change the date rendering format, the "real" date text in the cell stays the same. The only issue is that Excel decides what an acceptable "real" value is and modifies my input to match that.