398

Microsoft fixes the Excel feature that was wrecking scientific data(www.theverge.com)

posted
by
Avatar
misk@sopuli.xyz
in
Avatar
technology@lemmy.world
90 comments
hidereport
Sort:
HotTopControversialNewOld
You are viewing a single thread.
View all comments
Avatar
MelodiousFunk@kbin.social
114 points

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.

permalink
report
reply
Avatar
TwinHaelix@reddthat.com
12 points

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.

permalink
report
parent
reply
Avatar
Redacted@lemm.ee
7 points

Apart from actual dates.

permalink
report
parent
reply

Technology

!technology@lemmy.world

Create post

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

Community stats

  • 17K

    Monthly active users

  • 12K

    Posts

  • 555K

    Comments

Community moderators