Rikard Ågren Posted January 10, 2020 Report Share Posted January 10, 2020 Hello I have done some Data Sampling to CSV When opening the CSV in Excel or OpenOffice Calc, the date and time coloumns does not show the date and time values in the correct format. I manage to get date correct by adjusting the format of the date column to YY-MM-DD But the time column does not respond to adjusting the format, I have tried every option. Nothing happens with the values. What am I doing wrong? PRODUKTION_10-01-20___08-02-50.csv Quote Link to comment Share on other sites More sharing options...
Rikard Ågren Posted January 10, 2020 Author Report Share Posted January 10, 2020 Solved it, I had to search and replace the dot (.) with a comma (,) After this the values in the time column responds to the change of format (HH:MM:SS) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.