I’ve had cheap fake leather chairs do this because they get wet from my ass and back sweating all over them. But I’d replace them long before they got this fucked up.
I have the opposite problem. Half the time no matter how much I change the formatting on the cells I can’t get a table to sort by date. It insists on alphabetical instead, so you’ve got 1/12/2024 ahead of 1/13/2023.
When I worked in radio production, basically everything was formatted like YYYY-MM-DD. Which means stuff is really to find and properly in chronological order.
I still use the MM-DD format for my own file formatting, even though DD-MM is the Dutch standard.
YYYY-MM-DD is god’s perfect date notation as far as I’m concerned.
This is because you’ve accidentally input the values as text somewhere along the line. First make sure your format is set to date in the range in question.
Make use of the DATEVALUE formula in blank column =DATEVALUE(your_range). This will output your range as a number. Note that your_range needs to be in your computers date format (I have mine set to YYYY.MM.DD, so that what I have to use, else it won’t work. You might be American, so your dates would need to be MM/DD/YYYY) for DATEVALUE to recognise the text as a date string.
Then copy the output, paste as values only (alt, h, v, v), then copy that and paste it back into you range.
Make sure the format is set to date and you’re laughing.
Are there any rumors or claims that he actually is a pedo? I wouldn’t be surprised if he was, but he is a billionaire divorced dad with an ego larger than the moon.
lemmyshitpost
Newest
This magazine is from a federated server and may be incomplete. Browse more on the original instance.