I don't think there is a solution to this but I'm hoping.

I am using a macro to insert dates into a sheet. I want the dates to be formatted to display the month and year (mmm yyyy)

dim myDate as Date
myDate = DateSerial(2010,01, 01)
[A1].Value = Format(myDate, "mmm yyyy")

This works fine in English and inputs a date into the cell (01/01/2010) and displays "Jan 2010"

When I change the language of the computer to Polish the cell is inputted as "Sty 2010" in text only. If double click cell, only then does it understand that "Sty 2010" is 01/01/2010 and it fixes itself. Why would it work in English and not so well in Polish?

Can anyone think of a fix?