Trouble exporting date formats to Excel
Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt
Trouble exporting date formats to Excel
I'm trying to save a group in a workfile to an xlsx file using the pagesave command. Some of the members of the group are date series (this is an unstructured workfile). I set the display format of the date series to "mm/dd/yyyy", however when I save the group, the associated xlsx file shows them as "YYYY-MM-DD". Is Eviews doing the reformatting or Excel? Any suggestions you can offer will be appreciated.
-
EViews Jason
- EViews Developer
- Posts: 870
- Joined: Tue Sep 16, 2008 3:50 pm
Re: Trouble exporting date formats to Excel
We are looking into the issue and will keep you posted
-
EViews Jason
- EViews Developer
- Posts: 870
- Joined: Tue Sep 16, 2008 3:50 pm
Re: Trouble exporting date formats to Excel
EViews is writing the format. Unfortunately the format is hardcoded to YYYY-MM-DD and cannot be changed right now.
You will have to manually change the format within Excel by selecting the column and then applying the appropriate format.
You will have to manually change the format within Excel by selecting the column and then applying the appropriate format.
Who is online
Users browsing this forum: No registered users and 2 guests
