3 ms·
Aside from setting all your cells to text, they have added checkboxes for this now. https://insider.microsoft365.com/en-us/blog/control-data-conversions-in-exc
by simonh 2y ago
Aside from setting all your cells to text, they have added checkboxes for this now.
https://insider.microsoft365.com/en-us/blog/control-data-conversions-in-excel-for-windows-and-mac https://insider.microsoft365.com/en-us/blog/control-data-con...
- Eddy_Viscosity2 2y agoI just tried this out. I'm using office 2021 and when I first opened excel, this setting was there just like in the link and it seemed to work when I entered a few strings in. 'Fantastic!' I thought. Then I closed it and thought of a few other date-like strings to try and this time the option had disappeared! Every date-looking string was instantly turned into date! I tried a few other times and this setting is gone. WTF is that about?
- simonh 2y agoHave you opened an older file? Maybe it only works with files created with the feature. I’ve no idea why that would be the case, but it’s all I can think of.
- Eddy_Viscosity2 2y agoBoth times (and a few after that), it was accessing excel settings before opening any files or starting a new one. I've tried after opening files, same thing. The setting is just not there like it was the first time.