3 ms·
Yes and we in Europe use DD-MM-YYYY not MM-DD-YYYY. Excel is very dumb in how it deals with this. When it thinks dates should be DD-MM and you paste a bunch of
by GekkePrutser 6y ago
Yes and we in Europe use DD-MM-YYYY not MM-DD-YYYY.
Excel is very dumb in how it deals with this. When it thinks dates should be DD-MM and you paste a bunch of dates in MM-DD format it will parse the 'invalid' combos correctly (like 01-31) but it will leave the others alone. It should just realise "hey this is not the format I expect" and do them all correctly). Because if you don't notice you now have a whole bunch of half correct / half incorrect data and no way to tell which is which. it doesn't even flag the cells with a warning or comment. Or even pop up a warning to the user that something is off.
Also, if I paste a whole load of numbers starting with zeros then YES I want them as text, not for them to be changed to 1.374E+22. Great with stuff like serial numbers or IMEIs.
Microsoft with all their self-proclaimed AI chops should really apply some of that to Office. All these things have worked this way since the 90s.
PS: Part of the issue is also that MS doesn't have an intuitive application for databases, and because nobody groks Access everyone uses Excel as a database which it isn't. Causing a stinking pile un unmaintainable VLOOKUP crap.
- account42 6y ago> Yes and we in Europe use DD-MM-YYYY not MM-DD-YYYY. While you should be using YYYY-MM-DD. Please at least use a different separator if you don't.