Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

What date formats will Excel recognize as dates?

I've been using Jul 30/10 11:41:10 but Excel doesn't recognize this as a date.

I don't want to apply a function to the value, I just want to open the CSV file in Excel and "have it work". So I can change the format as needed, just want to know what the valid date format options are.

share|improve this question
1  
what system locale do you have? I think, you must enter the date according to your locale. –  netme Aug 2 '10 at 13:29

1 Answer 1

Netme is correct, the options are based on your locale.

If you click on a cell in Excel, and hit CTRL+1 (format cells), then go to the first tab and select the DATE category, it will list the valid options. It will also give you option to change locales.

edit - What is your source file? I know you said CSV but what system does it originate from?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.