Macos – Mac OSX Numbers – Convert text to datetime

conversiondate timemacos

I am using Numbers on a Mac. I have a CSV file which contains numerous dates in the format MM/DD/YYYY. I need to convert these dates into datetime format for insertion into a MySQL table. How do I convert strings of date format MM/DD/YYYY to datetime format YYYY-MM-DD hh:mm:ss ?

If hh:mm:ss defaults to 00:00:00, that is fine.

Best Answer

Highlight the column, click on Format near the top right if the format sidebar is not visible. In the sidebar, click on Cell. In the first dropdown choose Date & Time. Choose the 2014-01-23 style for date and 19:08:09 for the time.

Screenshot