this post was submitted on 21 Oct 2023
398 points (97.8% liked)

Technology

59010 readers
4268 users here now

This is a most excellent place for technology news and articles.

Our Rules

  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots

founded 1 year ago
MODERATORS
[email protected]
[email protected]
[email protected]
[email protected]
398
Microsoft fixes the Excel feature that was wrecking scientific data (www.theverge.com)
submitted 1 year ago by [email protected] to c/[email protected]
90 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 116 points 1 year ago (2 children)

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.

[–] [email protected] 13 points 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.

[–] [email protected] 6 points 1 year ago

Apart from actual dates.