how to remove #NA when using pagesave to export data from Eviews to excelsheet

[yj2283]

Hi, I am having one issues with pagesave. I need to export data from Eviews to excel sheet using pagesave. But I am seeing #NA instead of blank cells in excel for missing values. I did not see any option in pagesave that allows me to choose NA behavior. The only thing I can do now is to use "replace all" function in excel. It is a bit annoying, because I have to open several large excel files and manipulate them. Can anyone help me out?

[EViews Gareth]

Use na="" as an argument to the pagesave command.