this post was submitted on 16 Jan 2025
643 points (98.2% liked)

Engineering Memes

1366 readers
757 users here now

About:

Memes about engineering for all disciplines.

Rules:

General Rules:

  1. No hate speech
  2. No harassment, calls to violence
  3. No advertisement

Posts:

  1. Must be a meme/joke/observation/attempt at humour
  2. Must be engineering related (software engineer humour probably better suited for programmer humour communities, though not explicitly banned)

founded 2 years ago
MODERATORS
643
Get Dated (lemmy.dbzer0.com)
submitted 1 day ago* (last edited 1 day ago) by [email protected] to c/engineeringmemes
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 10 points 17 hours ago (17 children)

If I remember correctly Microsoft once responded saying that it can in fact not turn off that feature in Excel. Excel will always interpret your input and change it to what it thinks is correct

[–] [email protected] 13 points 16 hours ago* (last edited 16 hours ago) (16 children)

It's always been possible to format a range before inputting data. It won't be interpreted that way.

It only does that when it's formatet as "General" aka "Nobody knows what the fuck I'm about to do".

It would probably be more beneficial to change the default format to something else.

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

It would probably be more beneficial to change the default format to something else.

AfaIk this is not possible. Or MS doesn't allow it. User Defined would be pretty useless if MS would simply stop interpretating what I want to do in general

[–] DacoTaco 1 points 15 hours ago* (last edited 15 hours ago) (2 children)

You most certainly can. You can set the format of a cell, and if its set to number 12.5 will be 12.5, it wont even try date formats...

[–] [email protected] 1 points 10 hours ago (1 children)

Try opening a sheet sent by a Spaniard colleague. Good luck with decimals.

[–] DacoTaco 1 points 10 hours ago (1 children)

Thats a locale issues that excel has and cant fix ( for compatibility reasons ). Its one of the reasons i hate excel haha. But not related to cell types

[–] [email protected] 1 points 10 hours ago

No, I know. I can fix it, but old sheets and stubborn colleagues and clients and my fucking grandma won't.

My point was more related with excel manipulating input incorrectly because of Unspecified.

[–] pyre 2 points 15 hours ago

they're talking about defaults, as in when you create a new file the first thing you do is type a number and not get interpreted as a date.

load more comments (6 replies)
load more comments (12 replies)
load more comments (12 replies)