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?
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.
Time Format Not Exporting
Posted - 11/30/2021 : 4:20:47 PM
