*Cel

[email protected]

Can I ask though what that has to do with ignoring women? Do you mean all women altogether or just dating options?

object [Object]

You monster.

I've got a better idea... What if all mathematical calculations were done by chatgpt

[email protected]

If you precede all your data with an ', then excel won't auto convert it total a date. Seems silly to do this for all the data though.

Majorllama

Oh I know. You can do that or just add a single space as well. But you cannot do that before the document is created so if you import something into excel it'll just fuck all your numbers to shit and then you have to spend hours or days unfucking the numbers since even if you tell excel to treat that column as text only it won't put the numbers back correctly.

It's actually impressive how dogshit Microsoft products have become over the years. They clearly knew this was a problem back in 2016 or wherlnever that beta version was floating around where you could just disable the automated date feature entirely beforehand, but I guess they decided they liked pissing off office workers more than giving people meaningful QOL updates over the years.

[email protected]

The important lesson here is to never use excel sheets for any purpose.

Purpose built software, database gui, SQL or even CSV with data analysis tool will always work better for all purposes.

[email protected]

Wait, so if I were to import a csv with data that would normally be interpreted as a date by excel, but preceded that data with an apostrophe, it would still recognize that as a date? I've never tested this, so I'm not sure.

Relatedly, I know someone who was working some ssn data. Unfortunately, if an SSN started with a 0, it would drop that 0. It was a mess for them. I think there was a recent release that allowed you to not ignore leading 0's.

Majorllama

I've never personally tried adding the ' before you import but the one document that was causing problems with that for me recently was an auto generated document so I couldn't have possibly added any spaces or characters before excel went and messed them up anyways.

Majorllama

How is the S22 holding up? I've got an S23 which I got about a year ago and I have had battery protection on since I got the phone so my battery life is still 100% and I honestly can't see myself needing an upgrade for at least 3 more years.

[email protected]

https://lemmy.ca/post/2978749 it's made the rounds

[email protected]

It's been pretty nice. I started slacking on my charging schedule a few months after I got it, so it's degraded a little bit, but I can still make it through an 8-hour shift with Spotify going through my headset. The only thing motivating me to get something else is the locked down bootloader. I'd like to install something de-google-ified, but it's straight up impossible on the US version of the S22.

Majorllama

I've pretty much given up and just let Google have everything. I know that's an unpopular opinion around here and I totally get it, but I just can't be fucked to try and peel Google outta my life.