3 ms·
Most, but not all. That is the entire point: Excel is never safe in any configuration.
by corty 5y ago
Most, but not all. That is the entire point: Excel is never safe in any configuration.
- FabHK 5y agoNot 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.
- crazygringo 5y agoIf "not all", can you provide an example of what gets converted if you specify text? Just want to know to avoid future gotchas.
- HPsquared 5y agoI'm not sure, have to try it out but text fields can be delineated by starting with a single quote ('), that might be a special case. It might not be though, I don't have Excel open to check. Pretty much everything is left alone if you specify "text" at the import stage though. (This is using the text import wizard, or text-to-columns)