misk@sopuli.xyz to Technology@lemmy.worldEnglish · 1 year agoMicrosoft fixes the Excel feature that was wrecking scientific datawww.theverge.comexternal-linkmessage-square90fedilinkarrow-up1407arrow-down19cross-posted to: [email protected][email protected][email protected][email protected]
arrow-up1398arrow-down1external-linkMicrosoft fixes the Excel feature that was wrecking scientific datawww.theverge.commisk@sopuli.xyz to Technology@lemmy.worldEnglish · 1 year agomessage-square90fedilinkcross-posted to: [email protected][email protected][email protected][email protected]
minus-squareMelodiousFunk@kbin.sociallinkfedilinkarrow-up117arrow-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.