Forum Discussion
Format for time
Dear all, i transfer my file CSV to excel but the time format is different (last colume) could you pls help me how can i change time to same format? thank you very much
my original csv file has the same format as below, i openned them in the same way via excel
02/01/2024;;FMX0431;B06;;0000000186;;-5:36;;
02/01/2024;;FMX0431;B06;;0000000186;;-5:36;;
-5:36 is not a valid time in Excel...