Ask Your Question

Revision history [back]

When opening xls file in ods, data and time formats are not recognized

When I open a excel file that has date strings like 2017-11-02 and time like 11:45:35, LO opens them with data format 2/11/17 and 1/1/04. Why does it not automatically recognize them as valid dates and times, and is there anything I can do to fix that?