Ok worked out a solution for anyone updating to win 10 and having trouble opening csv files.
To change
- Settings - Time & Language
- Additional date, time & regional setting (at the bottom
-change date, time or number formats - Additional settings ... (Button)
Change the List Separator from the semi colon to a comma.(,)