Hello,

I have a .csv file that automatically opens up in Microsoft Excel 2010 and one of the fields is a date field that displays as Mar-13 (example);, but when you click in the field, it shows "March 13, 2013". How do I get this to display as is and not be automatically converted?

I've tried setting it as custom and put the date format in and I've tried setting it to a text field, but nothing seems to work.

Is there something in Excel, that automatically converts the date field to a specific format, and if so, how do I turn this off?



Thanks.