Date field

step10 · #1 10-29-2013, 04:05 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date field inserting merge date in blank field	Lesley	Mail Merge	5	09-30-2013 01:49 AM
Field Date: UCase()?	tinfanide	Word VBA	5	02-08-2013 03:01 PM
Date Field to add 10 Days to Current Date	Erbwon	Word	6	11-12-2012 06:17 PM
Please help me with creating due date field	Artemio	Word	1	03-01-2012 08:10 PM
Formula to subtract one month from due date field in reminder field	ghumdinger	Outlook	1	10-01-2011 12:09 AM