https://bugs.documentfoundation.org/show_bug.cgi?id=157973
--- Comment #2 from ady <[email protected]> --- Tools > Options > Language Settings > Languages > Date acceptance patterns. Additionally, when importing the plain text data, you can select each column (while still in the import dialogue) and select which type of data each column includes. Some of the options are D/M/Y, M/D/Y and others (instead of the standard text or numeric types of values). Once the data is correctly recognized as "date" after it was imported, the displayed format can be modified, for example as 'MMM DD, YYYY'. IMHO, this is a question for https://ask.libreoffice.org and for reading the official Help content; NAB. If I am misunderstanding the report, please provide a source data (as text or csv file) to be imported, (as opposed to the resulting spreadsheet). -- You are receiving this mail because: You are the assignee for the bug.
