.csv file saved with Excel, issue with date forma
I'm importing .csv file in Excel. After sorting it I'd like to save it in .csv format.
This works well except for the data field.
The import date/time format is: "mm/dd/yyyy hh/mm/ss.xxx"
In the excel file the format is automaticaly change in the cell with: mm.ss.x
All the information is still in excel (by cliquing on the cell I can see all the infomation)
But when saving it back in .csv format only "mm.ss.x" is saved all the "mm/dd/yyyy hh" is lost....
I tried differents excel date format, but couldn't find one which gives all :"mm/dd/yyyy hh/mm/ss.xxx"
Do you have a way to either,
- Open an .csv file and make excel treat the date column as a std string.
- Save in .csv format with all date information"mm/dd/yyyy hh/mm/ss.xxx"
thanks for you help,