I have data, imported from csv file. I have set date format on one column, and want to sort by date, but this seems only to sort by raw character values.
27/01/2015
28/01/2015
31/12/2014This almost certainly happens because of the import settings used when you opened the CSV file in the first place. Open it newly and find the “date” column, then play with the “column type” settings. (Text, dates, etc.) One of the “date” settings should be what you want. Also the check box “detect special numbers” may be applicable—I don’t know what other data you are dealing with.
When dates are stored as dates, not as text, they will definitely sort correctly.
(If this answers your question fully, please click the green check mark.)
We may also apply the tool > ‘Data’ > ‘Text to Columns…’ to the range of dates wrongly imported as text type data. This will offer the same options as the csv import dialogue.
Hey! I can’t get my CSV file to sort by date. The file that this was created from I see is not in order of date. This is very frustrating since it should be so simple. I can’t help that someone else (from work) can’t enter things in order. However, it should be a simple fix. I am completely new to LO. I upgraded my Mac OS and my old Mac MS Office no longer is supported.
Where do I go to “Data” > “Text to Columns”? From the upper pulldown menu or are these icons in the program? THANKS SO MUCH!