misk@sopuli.xyz to Technology@lemmy.worldEnglish · 11 months agoMicrosoft fixes the Excel feature that was wrecking scientific datawww.theverge.comexternal-linkmessage-square90fedilinkarrow-up1407arrow-down19cross-posted to: technews@radiation.partyhackernews@derp.foomicrosoft@lemdro.idtechnews@radiation.party
arrow-up1398arrow-down1external-linkMicrosoft fixes the Excel feature that was wrecking scientific datawww.theverge.commisk@sopuli.xyz to Technology@lemmy.worldEnglish · 11 months agomessage-square90fedilinkcross-posted to: technews@radiation.partyhackernews@derp.foomicrosoft@lemdro.idtechnews@radiation.party
minus-squareMelodiousFunk@kbin.sociallinkfedilinkarrow-up117arrow-down1·11 months 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·11 months 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.