I’m trying to convert my Etoro account statement into the CT format.
It requires mm/dd/yyyy hh:mm:ss date format.
This format does not work well in Excel. If the dd is below 13 it removes the seconds. If i change the data type to text it keeps the seconds, but it only keeps them if i save the file as .xls. Saving the file as .csv removes them again.
The problem being CT only accepts .csv files. What is the solution here?