Keep dates in the text format

I have a spreadsheet as CSV with dates. A column with dates is displayed correctly. On save the dates ar changed from the correct 08.18.2010 to the wrong 18/08/2010. What do I need to do to stop OO changing what is visible on the screen when saving

Hello @theking2
Please share a test file, we’ll check it out.