Rockwell Automation FactoryTalk Historian SE DataLink 4.2 User Guide - Manual (Page 35)

2
●
Basics
●
●
●
●
●
27
Display Formats
You can change the default time and number formats used by FactoryTalk
Historian DataLink to format data in function arrays. Default formats are
specified in the Settings (page 29) dialog box, where two settings are
available for formats:
 The default number format General formats numbers (and all non-
time stamp data) to match the formatting Category General in the
Excel Format Cells dialog box.
 The default time format dd-mmm-yy hh:mm:ss.000 matches the
standard FactoryTalk Historian time stamp format. You can add .000
to the end of the string (dd-mmm-yy hh:mm:000) to display sub-second
time stamps. Note that Excel does not support microsecond precision
formats.