We are creating .CSV files for data logging on a SNAP-PAC R2. The file contains a date and time stamp in one of the columns. When I open this file with notepad, the date and time is formatted correctly for us (hh:mm:ss.000, hours, minutes, seconds.ms). In excel, however, the hours are truncated and we’re left with mm:ss.0. Our server is receiving this file automatically and interpreting it as hh:mm.s. I know I can format the columns properly. The problem is that this CSV file is generated and sent with ftp to our server so I have no way of formatting the cells before ftp.
Can I use OptoScript to format the cells as the CSV is created?