Excel has the nasty idea to modify what you type in the cell. If it seems date-like or number-like, it will convert the content, possibly corrupting interesting details in the process.
You can of course counteract this with a quote or with formatting, but you have to remember to do this consistently.
I understand why they do it for a spread sheet: It is optimized for calculating. But this tendency makes excel untrustworthy for general processing.
You can of course counteract this with a quote or with formatting, but you have to remember to do this consistently.
I understand why they do it for a spread sheet: It is optimized for calculating. But this tendency makes excel untrustworthy for general processing.