-In Excel 2010, select Data, then "From Text" in "Get External Data"-It opens a file selection window; select the CSV file you want to open, click "Import"-For file origin, select "65001: Unicode (UTF-8)" - click next-leave "Tab" as the delimiter and click next-click "Advanced" and select the comma for decimal separator and period for thousand separator - click finishThe idea here is to get this macro to the clients so they can run it instead of the steps above every time the want to open a file with US formatted data.
Schakel JavaScript in om de bestand uploader te gebruiken.
vraagt om toegang tot een Wiki die Je hebt vergrendeld: https://connact.space/spaces/1/community-development/wiki/view/893/us-to-eu-csv-files