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

Engineering Memes

1366 readers
1 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
655
Get Dated (lemmy.dbzer0.com)
submitted 4 days ago* (last edited 4 days ago) by [email protected] to c/[email protected]
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 1 points 3 days ago* (last edited 3 days 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] 2 points 3 days 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.

[–] [email protected] 1 points 3 days ago (1 children)

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

[–] [email protected] 1 points 3 days 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 3 days 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.