However, Excel shows some - but not all - of the cells in
This is on a server in Germany.
Does anyone know what might be causing this, and how I can fix it?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
Import your CSV file using the the DATA tab. In the "Get External Data" section, select "From Text" file as highlighted in light green:
Navigate and select your CSV file from the pop up windows and press Import:
The "Text Import Wizard" step 1 of 3 should pop up. Configure it to suit your needs and press Next>:
On Step 2 of 3, configure your Delimeters for a check in Semicolon, and Other. In the Other box place a quote ". Make sure your check "Treat consecutive delimiters as one". Similar to image below:
Step 3 of three you need to select each of your columns with a date in it. Potentially 1 at a time. After you select a column, go up to the upper left area and select date. In the date drop down box select the format MDY. (you state in your question that your source data is in DMY format but if you look at the dates, the second set of numbers is greater than 12 meaning its the days.). When done press Finish
If you can get all your dates in as text without formatting applied you can also use TEXT to columns buttons to go through the same wizard.