Forum Discussion
Orange2045
May 21, 2024Copper Contributor
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
HansVogelaar
May 21, 2024MVP
Orange2045 The left-aligned values are probably text values even though they look like times. Do they contain spaces after the digits?
Orange2045
May 21, 2024Copper Contributor
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
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