9 ms·
Too many encounters with Excel’s “smart” date parsing would make me very concerned about using it this way. https://support.microsoft.com/en-gb/office/stop-aut
by macNchz 3y ago
Too many encounters with Excel’s “smart” date parsing would make me very concerned about using it this way.
https://support.microsoft.com/en-gb/office/stop-automatically-changing-numbers-to-dates-452bd2db-cc96-47d1-81e4-72cec11c4ed8 https://support.microsoft.com/en-gb/office/stop-automaticall...
- Rygian 3y agoThat page is such a gem. > "make it easier to enter dates. For example, 12/2 changes to 2-Dec" 12/2 is obviously the 12th of February in my locale. But I need to keep Excel in English as a company policy, so this is not only unhelpful, it's outright wrong. > Unfortunately there is no way to turn this off. How does Microsoft justify this choice?
- macNchz 3y agoI’ve never understood why they don’t provide the option to disable it, it’s not like Excel is a sleek, minimalist piece of software with strong opinions and limited configuration. I also love how the support article describes a behavior of their own software as “very frustrating”.