When you go to format cells, how do you see the date? If I have mine set to "English(Canada)" I get 14/03/2012. Changing to English(United States) I get I get 3/14/2012. Now, this will only function on those cells in that sheet. Excel uses system defaults, which you should be able to change in the language control panel applet.
|