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