this post was submitted on 16 Jan 2025
643 points (98.2% liked)
Engineering Memes
1366 readers
758 users here now
About:
Memes about engineering for all disciplines.
Rules:
General Rules:
- No hate speech
- No harassment, calls to violence
- No advertisement
Posts:
- Must be a meme/joke/observation/attempt at humour
- Must be engineering related (software engineer humour probably better suited for programmer humour communities, though not explicitly banned)
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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...
Try opening a sheet sent by a Spaniard colleague. Good luck with decimals.
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
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.
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.