I see that it is possible to specify date formats by storing the numeric representation of the date in the sheet.Range[CellNo].Number member and a format string in the sheet.Range[CellNo].NumberFormat field. The problem is, specifying a format here (say, "m/d/yyyy h:mm") is not localizeable.
Within Excel, if you format a cell as Category: Date, and then select one of the few Types that are localizeable (denoted with a '*' as seen in the attached screenshot), the spreadsheet will display the date in that general format, but localized. That is to say, it will display as “3/9/2007” on an American English machine, and “9/3/2007” on a Spanish machine.
Is it possible to specify a cell as a Date cell so that Excel will automatically format it and allow for localization? If not, is there a workaround for localization?
dateformat.zip