Converting text fields into date fields
You might have a spreadsheet of dates that are in fact only text fields, and subsequently can't be sorted in the same way as a date field can. This article gives you a procedure for converting all those text fields into proper date fields.
Method
Open the spreadsheet file in LibreOffice Calc.
- Select the column of 'dates' that you want to convert.
- On the Main menu, go to Data > Text to columns.
- In the dialog box that appears, click the column that you want to work with.
- For Column type, choose the date format that best represents the data in your column.
- Click OK
All your data should now be converted to date types.
Thanks for visiting.