3 ms·
Not sure about that. It is my understanding that Excel only tries to guess the type of an input if it has not been explicitly specified by the user. The proble
by FabHK 5y ago
Not sure about that. It is my understanding that Excel only tries to guess the type of an input if it has not been explicitly specified by the user.
The problem with "things that look like dates being interpreted as dates" comes from not specifying that a column has type "text".
- Xelbair 5y agoEven if you do specify a column as a text excel WILL assume that it contains dates sometimes. Happened to me multiple times, even when i set each cell as a text. Seems like copypasting a tab separated values resets the cells to their default state.