misk@sopuli.xyz to Technology@lemmy.worldEnglish · 1 年前Microsoft fixes the Excel feature that was wrecking scientific datawww.theverge.comexternal-linkmessage-square105fedilinkarrow-up1403arrow-down19
arrow-up1394arrow-down1external-linkMicrosoft fixes the Excel feature that was wrecking scientific datawww.theverge.commisk@sopuli.xyz to Technology@lemmy.worldEnglish · 1 年前message-square105fedilink
minus-squareMelodiousFunk@kbin.sociallinkfedilinkarrow-up116arrow-down1·1 年前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.
minus-squareTwinHaelix@reddthat.comlinkfedilinkEnglisharrow-up13·1 年前 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.