this post was submitted on 02 Jul 2025
501 points (96.5% liked)

Microblog Memes

8477 readers
3338 users here now

A place to share screenshots of Microblog posts, whether from Mastodon, tumblr, ~~Twitter~~ X, KBin, Threads or elsewhere.

Created as an evolution of White People Twitter and other tweet-capture subreddits.

Rules:

  1. Please put at least one word relevant to the post in the post title.
  2. Be nice.
  3. No advertising, brand promotion or guerilla marketing.
  4. Posters are encouraged to link to the toot or tweet etc in the description of posts.

Related communities:

founded 2 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 9 points 1 week ago* (last edited 1 week ago) (11 children)

Wouldn't it be February first as the default in excel?

Edit: I tested this with excel. I typed “1/2” and it automatically converted it to “02-Jan”

[–] [email protected] 13 points 1 week ago (1 children)

Yes, 1 February It would have been for most. Now it's just an north american joke

[–] [email protected] 5 points 1 week ago (2 children)

I just tested, entering “1/2” into excel results in “02-Jan”

Truly cursed.

[–] [email protected] 2 points 1 week ago (1 children)
[–] [email protected] 2 points 1 week ago (1 children)

0.5 but keeps the fraction in the formula bar.

That one doesn’t surprise me at all.

[–] [email protected] 2 points 1 week ago (1 children)

Then go format as date on the cell

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

Jan 1, 1900

And as a time it’s exactly 12 PM

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

Weird. When I entered 0.5 as a raw figure it gave me Jan 0, 1900 at 12 pm.

[–] [email protected] 4 points 1 week ago (1 children)

I think it should follow regional settings, but don't have high hopes (nor much the experience)

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

This brings back memories of trying to match locale info from my local computer, a remote server, a MySQL db, and a different Python app in a different server region.

It was for an international email campaign so each users email needed to match their in app locale for number and currency formatting, but there were like a half a dozen different layers of apps and servers that all handled locales differently.

Add in a hard deadline for the client and oof, that was a painful week.

LC_ALL=C is now cursed knowledge that resides in my brain. I wasn’t able to install Babel or any other libraries because security reasons so I had to handle everything manually.

load more comments (9 replies)