I am pulling data off a database where the date is in this format - yy/mm/dd.
When I open up the data in excel a date of 1st of October 2008 becomes the 8th of October 2001.
If I open up the data format properties in regional settings in control panel, and then choose yyy-MM-dd and click OK I get
“One of the characters you have entered is invalid”
I HAVEN’T ENTERED ANY FUCKING CHARACTERS!!!
If I simply change the lot to US Excel won’t recognise this change until I reboot. So I’ll have to make the change, reboot, run the query, change it back, reboot again.
fuck about with the query re-arranging the dd mm and yy using the substring function, and then delete the fuckwankbollocks columns within excel because I want to use the * (there are a lot of columns)
Why can’t excel just fucking let me tell it “THESE ARE AMERICAN DATES IN THE FORMAT YY/MM/DD SO LEAVE THEM THE FUCK ALONE FUCKROSOFT EXWANK”
“ACTUALLY - LEAVE THE REST OF THE DATA THE FUCK ALONE IF I WANT YOU TO LEAVE IT THE FUCK ALONG O-FUCKING-K???”
And before anyone says. I know yy/mm/dd isn’t the main us format (or is it) but it is A us format and when my computer is all in US mode then it works.
But I don’t want it in US mode because then my @ and " keys are in the wrong place.