Reply to thread

Message: [QUOTE="Drdul, post: 6801391"] It looks like Excel is hard-wired to accept dates input as M/D/Y, which is the American format. Here in Canada (as in the rest of the world), we write D/M/Y. I can't find anything to change this in Preferences, and Excel is apparently not picking up the system date settings from OS X. This is *not* a cell formatting problem. I have the cells formatted to display the date as DD-MMM-YY, and dates are displaying correctly (once I figure out how to enter them correctly!). Even though the dates display correctly in the spreadsheet, they display in the American M/D/Y format in the formula bar. I am wasting a lot of time with this, as I keep entering dates wrong (40+ years of doing it one way is difficult to unlearn!). Is there some secret setting that I am missing that would allow me to set Excel to default to accepting dates in the D/M/Y format, and displaying them that way in the formula bar? [/QUOTE]