1. Home
  2. Formatting Date/Time in Spreadsheet Columns

Formatting Date/Time in Spreadsheet Columns

In Genstat you can apply a date or time format to a complete column (but not cell by cell as you can in Excel).

  1. Right-click the column you want to format and select Column Attributes or use the shortcut key F9.
  2. Click Date format.

     

  3. Select a date or time format from the dropdown list (time formats are at the bottom of this list).
    You can also select Custom <various> (the last option in the list), which activates the Custom date format dropdown list (see Creating a Custom Date/Time Format).

  4. Click OK twice to apply your format to the column.

You can use different date formats within a spreadsheet by using the method described above to apply formats to individual columns.

Updated on March 1, 2019

Was this article helpful?