Last Update: 10/14/2020
Recent versions of Origin have made import of date-time data much easier, particularly with the addition of the Text/CSV Data Connector, which will automatically handle formatting of commonly-recognized date-time formats.
That said, you may encounter situations -- particularly if you are using non-standard date-time formats -- in which your date-time data are not automatically formatted on import. You can quickly spot problems by looking at alignment of data in the worksheet cell: if date-time data are left-aligned they are being treated as text, and not date-time (which is stored internally as numeric). This FAQ will show you how to display your date-time data in the desired format.
To convert text data to numeric data or to change the display format of data, do the following:
Keywords:format, date, display