The date format problem is one of the weaknesses of Excel. If you want to create internationalized worksheets that work in every country you have to detect the local regional settings and internationalize all formatting, input parsing and formula generating formulas.