Hi.
Could you explain please, how I can switch off automatic date formatting in Calc?
I need to enter dates in different formats, and Calc re-formats them, and after this even manual formatting doesn’t always help 
Date recognition depends on the locale in use and which date acceptance patterns are effective (see Tools - Options - Language Setting - Languages). However, even if a date is recognized and reformatted using one of the standard date formats, it should be possible to apply a different date format. So we’d need more information what exactly goes wrong and in which locale.