CODEWITHSUNDEEP
datetype-conversionlibreoffice-calc
rexkogitans
rexkogitans

Reputation: 314

LibreOffice: Cells with text to date

I have loaded an xlsx file where the original author used Microsoft Office to create the file. In the spreadsheet, there is a column of dates given in format like "DD/MM/YYYY TT:MM:SS", but they are stored as text. Furhteron, "DD/MM/YYYY TT:MM:SS" is not locale default. I cannot find a way to make LibreOffice interpret it as date. Can someone please help me to reach my aim?

Upvotes: 0

Views: 2398

Answers (1)

Lyrl
Lyrl

Reputation: 935

Highlight the column of dates. From the menu, select Data -> Text to columns. In the dialog window that pops up, press "OK". That should do it.

Upvotes: 2

Related Questions