https://bugs.documentfoundation.org/show_bug.cgi?id=161552
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #1 from Eike Rathke <[email protected]> --- The "dates" weren't imported as numeric dates but text strings that look like dates (hence the leading ' apostrophe when viewing the cell to indicate it could be a date if it wasn't text). In the CSV import dialog either choose a proper import locale that matches the data, e.g. English-US, or set individual column types to Date MDY in this case. See also this FAQ https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data Not a bug. -- You are receiving this mail because: You are the assignee for the bug.
