Converting text  fields into date fields

LibreOfficeYou 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.

  1. Select the column of 'dates' that you want to convert.
  2. On the Main menu, go to Data > Text to columns.
  3. In the dialog box that appears, click the column that you want to work with.
  4. For Column type, choose the date format that best represents the data in your column.
  5. Click OK

All your data should now be converted to date types.

 

Thanks for visiting.