Have You Seen Historian Lately?Click here to check out all the new features in the latest version.
Supercharge your GE solution! Download a free trial of Proficy Operations Hub, CSense analytics, and more. Learn more about the Proficy 2022 releases, by signing up for one of our upcoming events.
This topic describes how to format the date/time column
for Historian tables in Excel if you need to display a specific date format. For more
specific information on formatting spreadsheets, refer to the Microsoft Excel online
Help.
Procedure
Right-click the heading of the column that you want to format.
Select Format Cells > Number.
Select Date.
In the Type field, select the date format that you want
to use.
To display milliseconds, instead of selecting the Date
category, select Custom, and then enter
dd-mmm-yyyy hh:mm:ss.000 in the
Type field.
Historian