Wrong datatype in CSV import

[lb85]

Hi all

I face a problem when importing data from a CSV file to Eviews 6 that I have not come across yet.
The CSV file is organized as a stacked panel file (monhtly data) and I have about 6 variables in the file which should all have numeric datatypes. But somehow, Eviews incorrectly recognizes two of the variables as characters even though they're exactely the same as the other 4. I have also made sure in Excel that they all have numeric cell format, but this doesn't help.

Do you have any idea why Eviews is not importing these two variables correctly? I have many NA in the file, as it's unbalanced. But this is also the case for the 4 variables that are correctly recognized.

Your help is highly appreciated!

[EViews Gareth]

Hard to tell without seeing the Excel file.

[lb85]

Hi Gareth

I tried to upload the xlsx file but it's too large (~8MB) and even a zip file is larger than the threshold of 2 MB.
Can I send it by e-mail?

[EViews Gareth]

Sure, support@eviews.com