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 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) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now