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.

We create files with dates in them in the form dd/mmm/yyyy. These spreadsheet files are in html format with extension .xls (Further info: created via HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";)

When I load one of these files into Excel 2007 on my Win7 machine the dates all appear as dd-mmm-yy (e.g. "28-Jun-2010") - and this is the same behaviour as when we load the files into older Excel programs also localised English.

When this same file is loaded into Excel 2002 NL on XP that is localised Dutch (and that I do not have access to) some dates appear as dd-mmm-yy but other dates appear as dd/Mmm/yyyy.

This seems to be down to the month element of the date:

Months with "Oct", "Mar" or "May" in them appear as dd/Mmm/yyyy (e.g. "30/Mar/2010") other months appear as dd-mmm-yy (e.g. "28-jun-10")

When I look at the cell format info the cells I get "custom"/"dd-mmm-yy" for cells that appear as dd-mmm-yy and "General"/"no specific number format" for those that show as dd/Mmm/yyyy.

Why those particular months? I assume down to localisation? Is there a way to get all the dates displayed consistently without having to manually alter the tables?

Is there a setting in Excel NL to do this?

Update: Just checked - May, March, & October are the three months where the short three-letter form of the month does not match in both English and Dutch (the other months do.) Therefore this is why these dates are not being picked up as dates.

Is there a way to enable Excel to pick these up as dates - even though the short form does not match the English?

share|improve this question

1 Answer 1

To the question: "Why those particular months?"

All the other abbreviations of months are the same in Dutch as they are in English.

Jan  Jan
Feb  Feb
Mar  Maa <--
Apr  Apr
May  Mei <--
Jun  Jun
Jul  Jul
Aug  Aug
Sep  Sep
Oct  Okt <--
Nov  Nov
Dec  Dec

As you can see, only March, May and October are different from dutch when abbreviated.

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.