https://communities.sas.com/t5/SAS-Visual-Analytics/Trouble-keeping-date-format-when-exporting-to-Excel/m-p/471437#M10493 <P>Hi SAS VA community!</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>For example, I have this graph&nbsp;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... <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="columnas.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/21272i7323569222A56DF7/image-size/large?v=v2&amp;px=999" role="button" title="columnas.png" alt="columnas.png" /></span></P><P>&nbsp;</P><P><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/21271i90361D781D2F2C7F/image-size/large?v=1.0&amp;px=-1" border="0" width="600" height="480" title="sample.png" alt="sample.png" /></P><P>&nbsp;</P><P>Please, any help will be much appreciated!</P><P>&nbsp;</P><P>Thanks in advance, regards;</P> Tue, 19 Jun 2018 16:34:44 GMT GuillermoPH 2018-06-19T16:34:44Z https://communities.sas.com/t5/SAS-Visual-Analytics/Trouble-keeping-date-format-when-exporting-to-Excel/m-p/471437#M10493 <P>Hi SAS VA community!</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>For example, I have this graph&nbsp;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... <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="columnas.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/21272i7323569222A56DF7/image-size/large?v=v2&amp;px=999" role="button" title="columnas.png" alt="columnas.png" /></span></P><P>&nbsp;</P><P><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/21271i90361D781D2F2C7F/image-size/large?v=1.0&amp;px=-1" border="0" width="600" height="480" title="sample.png" alt="sample.png" /></P><P>&nbsp;</P><P>Please, any help will be much appreciated!</P><P>&nbsp;</P><P>Thanks in advance, regards;</P> Tue, 19 Jun 2018 16:34:44 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Trouble-keeping-date-format-when-exporting-to-Excel/m-p/471437#M10493 GuillermoPH 2018-06-19T16:34:44Z https://communities.sas.com/t5/SAS-Visual-Analytics/Trouble-keeping-date-format-when-exporting-to-Excel/m-p/473447#M10544 <P>Just a quick sanity check: did you try expanding the excel column with the ### values in it? &nbsp;I have sometimes had excel represent values that way until I expand the column width enough to show the full values. &nbsp;</P> Tue, 26 Jun 2018 15:59:55 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Trouble-keeping-date-format-when-exporting-to-Excel/m-p/473447#M10544 MikeJenista 2018-06-26T15:59:55Z