Trouble keeping date format when exporting to Excel

[GuillermoPH]

Hi SAS VA community!

I'm dealing with a situation that is driving me nuts: when I choose to export data from a VA report to Excel, it messes up with date formats.

For example, I have this graph I need to export in order to work with the data, it has a date variable named FECTERMINADO which in EG I set its format as datetime27.6; in VA it is formatted as MMMYYYY. When I export it to Excel I get a bunch of ##'s. I've tried everything but I keep failing on keeping the format... 😞

Please, any help will be much appreciated!

Thanks in advance, regards;

[MikeJenista]

Just a quick sanity check: did you try expanding the excel column with the ### values in it?  I have sometimes had excel represent values that way until I expand the column width enough to show the full values.