Have You Seen Proficy Historian Lately?Click here to check out all the new features in the latest version.
Supercharge your Proficy solution! Download a free trial of Proficy Operations Hub, CSense analytics, and more. Learn more about the Proficy 2025 releases.
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.