Microsoft fixes the Excel feature that was wrecking scientific data

misk@sopuli.xyz to Technology@lemmy.world – 394 points –
Microsoft fixes the Excel feature that was wrecking scientific data
theverge.com
88

You are viewing a single comment

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.

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.