When save an Excel to csv, the seconds automatically become 0?

111 Views Asked by At

I am trying to save an Excel file with date time as a csv file. Here is the date and time in the Excel:

enter image description here

You can see the seconds are there although they are not shown in the cells. But when I save it as csv using:

enter image description here

You can see that the seconds are still there, but they all become 00.

enter image description here

So I actually lose the seconds. How to keep them?

0

There are 0 best solutions below