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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to enter start and end date/time in excel based on some specific value. 7
Do a two way lookup and get the result in multiple columns 2
Access Running Balance in Access 1
Find then highlight in yellow 6
Hot Date 4
Insert Blank Line and Sort 3
yet another date format problem 1
Conditional Formatting - Dates 2

Back
Top