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
6 Replies
Orange2045 The left-aligned values are probably text values even though they look like times. Do they contain spaces after the digits?
- I have 4 big csv files, and i need to put them together and delete the double lines. but once i open them via excel , they dont show the same format for the date.
do you know what will be the best way to do that? if there is a way that i can do it directly in csv file instead of in excel? thank you - 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;;-5:36 is not a valid time in Excel...
