2.38 FAQ-472 How to set the date format if the data is not consistent with the desired display format?

Last Update: 1/3/2019

Unless you are using an Origin import filter or you are specifying a Custom Date Format in the impASC dialog box, chances are your data will be treated as Text & Numeric data on import (you can make a quick determination by looking at alignment of data in the worksheet cell: if data are left-aligned they are being treated as text, if they are right-aligned, they are being treated (correctly) as numeric data).

To convert text data to numeric data or to change the display format of data, do the following:

  1. Double-click on the column heading to open the Column Properties dialog and set Format to Date.
  2. Click the Display list and pick the corresponding date-time syntax string from the list and click Apply. For guidelines on date-time syntax, see Dates and Times in the Worksheet.
  3. If a suitable format is not available from the list, you can define your own in one of two ways (refer to the syntax in the previous link):
    • Pre-define the string in the Custom Date Formats of Preference: Options (Miscellaneous tab). The string then appears as one of the two "Global Custom" display formats available from the Display list.
    • Set Display to Custom Display and enter your string directly in the Custom Display box that becomes available. Your custom format will be added to the Custom Display list and can be used in future sessions.
    Custom date format column properties.png

Keywords:format, date, display