Hi Ursula, When a CSV file is opened in Excel, Excel tries to guess the data type of each cell.  If the cell only contains numbers and some symbols (e.g., /) it will interpret it as a date.  This is regardless of the data type of your original SAS dataset.  Excel, however, does not support incomplete dates so it also tries to complete your dates, and sometimes it does it right and sometimes not.  On top of that, once the date is complete, Excel applies a format to the cell to display the date in a certain way.  You can't change how Excel treats dates, so depending on what your end goal is, I would suggest one of the following two options: 1-In your SAS dataset, i.e., before exporting as CSV, add an apostrophe/single quote (') before the incomplete date, and then make sure this symbol appears in the CSV file.  When Excel opens the CSV file, it will interpret the cell as text and will show exactly what you want.  However, you won't be able to do calculations or sorting in Excel with this field. 2-In your SAS dataset, complete the date (e.g., '03/2015' should be '03/01/2015' or '01-Mar-2015') and then convert it to a date field with the input function.  Excel will consistently import a complete date correctly. I hope this helps, Daniel ... View more