Date field showing up as day-month when it should be mm/yy

Kristen

Guest

Posts: n/a

22nd Sep 2011

I am exporting from a web report where the field shows up as MM/YY.
When I export to Excel the column shows up as DD-Month. So 05/09
becomes 9-Dec. 05/05 becomes 5-May. I cant get it to format correctly.

Any ideas?

« Excel formula translator - EN | date in excel »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Form Field of Date Type Not Keeping Month Portion Of Date	Ronald R. Dodge, Jr.	Microsoft Word Document Management	1	20th Oct 2008 11:46 AM
date format only showing month year	=?Utf-8?B?bmlra2lhYm0=?=	Microsoft Excel Misc	4	30th Apr 2007 08:52 PM
bind data to anothermfield. Date field to Month field.	=?Utf-8?B?cGdyb2JpbnNvbg==?=	Microsoft Access Form Coding	6	15th Sep 2005 05:21 AM
bind data to anothermfield. Date field to Month field.	=?Utf-8?B?cGdyb2JpbnNvbg==?=	Microsoft Access Database Table Design	1	13th Sep 2005 12:11 AM
date field cannot be more than 1 month from prior date field crite	=?Utf-8?B?YXRuc3g4MA==?=	Microsoft Access Forms	1	11th Apr 2005 11:12 PM