Forum Discussion
Incorrect date format when using text to columns
Craig, it looks like due to time added to that field. If time is not important for you (i.e. it always 0:00:00) you may open csv file and Text to Columns last column with space separator, remove time only column after that.
See result attached. If the time is important will find somethin else.
Hi Sergei - I've tried this method also but it still ends up with the same results. It converst the ones with days less than or equal to 12 and ignores the rest !! Very frustrating.
Craig, could you please attach text file (or part of it) from which you import?
Here you go....I've had to change the extension from TXT to csv as it wont let me upload a txt one.
Craig, it looks like due to time added to that field. If time is not important for you (i.e. it always 0:00:00) you may open csv file and Text to Columns last column with space separator, remove time only column after that.
See result attached. If the time is important will find somethin else.
Well it didnt work exactly the way that you thought it would but I've managed to find a solution. Unfortunatley I havent been able to find the route cause of the problem so will have to carry out this work around every time I need to carry out the same action. Thanks for your help Sergei.