Import - Eviews converts numbers to dates

[ErikG]

Hi,

I've got an excel file with a column filled with numbers formatted as text. When importing the data to an unstructured Workfile Eviews converts these numbers to quarterly dates. This didn't happen about a year ago using Eviews 9. Can I force Eviews to read each column as a string?

Thanks,
Erik.

[EViews Gareth]

Yes, on Step 2 of the Excel Read dialog you can use the Data Type box to change the type.

[ErikG]

And in code how do I do this if I have different data types in different columns in the excel sheet?

/Erik.

[ErikG]

OK, I See, this is the types option.