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... 😞
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.