Paul Gleichmann Posted October 2, 2020 Share Posted October 2, 2020 Hello,Ive been having this problem in PVsyst output files.The hourly data file in the .csv format contains numbers with dots, so far so usual. But excel recocnizes some of those numbers with dots that count as a comma, and some with dots that count as a european delimiter (as in 10.000 m).This results in completely unrealistic values. 150.36 kW of electrical power inserted to the grid on a certain hour can be read as 150,3 kW or 150.360 kWI tried to convert the .csv file into an usual .xls fileI also tried in excel: File < Options < advanced < Use delimiter character accordingly to OS language setting, but the problem keeps on occuring.Is there a solution to this subject?Sincerely,Paul Link to comment Share on other sites More sharing options...
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 account
Already have an account? Sign in here.Sign In Now