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

[Kristen]

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?

 

[Ron Rosenfeld]

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?

You are going to have to import the date as "Text", and then convert it using a formula.

For example, with the text string 05/09 in A3:

=DATE(RIGHT(A3,2)+1900+100*(--RIGHT(A3,2)<30),LEFT(A3,2),1) --> 1 May 2009

You can then format it however you want with a custom format.

If this does not make sense, please provide precise details as to exactly how you "export to Excel".