Date format switch

[RonEmm]

From an import file I retrieve o.a. cells that contain a date. The date is in the format dd-mm-yy. At the end of the data, for some reason a blank is added so the complete contents looks like e.g.: "01-06-10 "

After copying that cell into a new worksheet manually and pressing F2 the blank is gone and the date looks like "01 jun 2010", which is correct. I tried doing the same using VBA but then the day and month are switched so instead of June 1, I get January 6 using the same format "dd mmm yyyy". Local settings already are set to Dutch.

Does anyone know a solution so I can keep using VBA?

I use Office 2007 - Dutch.

Thanks!

 

[schielrn]

Maybe try using text to columns in vba. You can record a macro and in the 3rd step there is a date radio button and you can choose your format such as MDY or DMY or so forth.

Maybe that will help?

 

[RonEmm]

This certainly worked! Thanks!