| T O P I C R E V I E W |
| Accel_01 |
Posted - 11/30/2021 : 4:20:47 PM
OriginPro 2021 9.8.0.200
Operating System:Win10
In my worksheet the Time column is in a custom format of DDD HH:mm:ss.000 When the worksheet is exported to a .csv file, the time format does not export. Instead it looks to be converting to a number or text, ex: DDD.0000. Is there a way to keep the time in the same format when exporting? |
| 2 L A T E S T R E P L I E S (Newest First) |
| Accel_01 |
Posted - 12/01/2021 : 10:07:21 AM
Thanks for the screenshots, they were key.
I noticed that the window where you specified the custom format was different than what I used. Instead of highlighting the column and selecting Properties like in your screenshot, I selected Format Cells... and did the custom time that way. Using the Properties and exporting to csv works. Using Format Cells... to define a custom time and then exporting to csv does not work. |
| snowli |
Posted - 11/30/2021 : 5:07:24 PM
I couldn't reproduce the issue with custom format set to DDD HH:mm:ss:000.
But shouldn't the custom format be DDD HH:mm:ss:###?
E.g.
Enter some time value and also put some data in column B.
Use File: Export: ASCII and choose csv file extension with default settings.
I got
Thanks, Snow |
