date format

  • Thread starter Thread starter gil.qi.zhang
  • Start date Start date
G

gil.qi.zhang

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
 
Back
Top