CSV file funny characters

[PeteKnight]

All you have to do is search the forum…

Easiest way to export CSV and view in Excel

Well, It’s fairly easy when someone has done it before you and you just google the answer, which is what I did In English the formula would be: =(((A1/1000)-(7*3600))/86400)+(DATEVALUE("1970-01-01") - DATEVALUE("1900-01-01")) To display the converted time in a more readable format you can choose Custom formatting and adjust the way that you want the data to appear: [image] If you go for dd/mm/yyyy hh:mm then it’s easier to read (unless you’re American and ins…

Pete.