I created an account on this forum specifically to THANK MathUHenry for posting a working solution to this problem.
I'm one of those random people who uses a search engine to try and figure out how to fix things. In this case, I was growing increasingly exasperated by OpenOffice Calc automatically adjusting the date I was entering into a spreadsheet. I kept thinking... WTF is going on? Can't this MF'ing software just KEEP what I'm typing in?! So annoying!
Your instructions proved to be FANTASTIC!
So... thank you!