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

Technology

59689 readers
3200 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]
[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] 37 points 1 year ago (2 children)

Now if only it would stop dropping leading zeros unless you ask it, and we got rid of the MM/DD/yyyy date format entirely.

[–] [email protected] 8 points 1 year ago (1 children)

Now if only it would stop dropping leading zeros unless you ask it

That appears to actually be a feature.

[–] [email protected] 1 points 1 year ago (1 children)

Holy shit! Now I just need to talk to some sysadmins and get some group policies set.

[–] [email protected] 1 points 1 year ago* (last edited 1 year ago)

Apparently our typical installer for Visio 2016 and our 365 license use "incompatible installers" so it is going to be a pain in the ass for me to have both installed at the same time. Thankfully I'm trusted by IT so I might be able to just do it myself.

Edit: Looks like I'll need IT after all. https://learn.microsoft.com/en-us/deployoffice/use-the-office-deployment-tool-to-install-volume-licensed-editions-of-visio-2016

[–] [email protected] -1 points 1 year ago (1 children)

MM/DD/YYYY is the correct format here in America.

[–] [email protected] 9 points 1 year ago (1 children)

I think the point was that the format itself is odd. I am European and it's weird to me: logically it should be either from greatest to smallest, or from smallest to greatest, not a weird in-between.

[–] atzanteol 3 points 1 year ago (1 children)

Logically it would be milliseconds since 1970.

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

Not very good for birthdates.