Important: You do not have the latest version of Historian! You are missing out on the newest capabilities and enhanced security. For information on all the latest features, see the Historian product page. For more information on upgrades, contact your GE Digital sales agent or e-mail GE Digital Sales Support. For the most up-to-date documentation, go here.

Formatting Dates and Times in Excel

Procedure

To select the column you want to format, select its heading.
Right-select the selected column.
Select Format Cells from the right-select menu.
Select Number, if it is not already selected.
Select the Date category.
Select a timestamp type in the Type group box.
- If you need 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.
Select OK.