hello ...
I have imported an excel sheet and for some reason it is treating cells differently after the 'O' column (which is the 15th column) from excel ...
in the picture you can see the excel sheet with four cells highlighted ... and in the right you can see those same cells highlighted, but with ellipses in one and an NA in the other ... in excel both are of the same cell format category 'General' ...
any thoughts as to why the cells after O are being treated differently ??
- thanks for your time ...
importing excel with blank cells: sometimes ellipses, sometimes NA's
Moderators: EViews Gareth, EViews Moderator
Re: importing excel with blank cells: sometimes ellipses, sometimes NA's
SOLUTION:
the problem was that in he excel file the first row of data for the columns through 'O' were blank and so eViews was creating them as alpha columns/series ...
the problem was that in he excel file the first row of data for the columns through 'O' were blank and so eViews was creating them as alpha columns/series ...
Return to “General Information and Tips and Tricks”
Who is online
Users browsing this forum: No registered users and 8 guests