misk@sopuli.xyz to Technology@lemmy.worldEnglish · 1 year agoMicrosoft fixes the Excel feature that was wrecking scientific datawww.theverge.comexternal-linkmessage-square90fedilinkarrow-up1407arrow-down19
arrow-up1398arrow-down1external-linkMicrosoft fixes the Excel feature that was wrecking scientific datawww.theverge.commisk@sopuli.xyz to Technology@lemmy.worldEnglish · 1 year agomessage-square90fedilink
minus-squareMelodiousFunk@kbin.sociallinkfedilinkarrow-up116arrow-down1·1 year agoMe before reading the article: It’s got to be dates. Excel thinks everything is a date. Me after reading the article: Even the workaround is halfhearted. Jeebus.
minus-squareTwinHaelix@reddthat.comlinkfedilinkEnglisharrow-up13·1 year ago Microsoft’s blog adds caveats, such as that Excel avoids the conversion by saving the data as text, which means the data may not work for calculations later. There’s also a known issue where you can’t disable the conversions when running macros.
Me before reading the article: It’s got to be dates. Excel thinks everything is a date.
Me after reading the article: Even the workaround is halfhearted. Jeebus.
Apart from actual dates.