importing excel with blank cells: sometimes ellipses, sometimes NA's
Posted: Mon Sep 14, 2020 3:08 am
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 ...
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 ...
- screenshot_eviews_4.png (404.38 KiB) Viewed 14614 times