04/11/05 is 2005/11/04 but Excel thinks it's 2004/11/05. I have many
this kind of date need to be correct. Anyone knows how to do it in the
simplest way? Thank you very much.
This is purely a guess, but I think I'd play around with regional settings
for this.
Start -> Control Panel -> Regional and Language options
> 04/11/05 is 2005/11/04 but Excel thinks it's 2004/11/05. I have many
> this kind of date need to be correct. Anyone knows how to do it in the
> simplest way? Thank you very much.