Hi,

I have a strange behaviour with Excel 2013 on Windows 8. First time I see this with Excel.

My regional settings for short date format are set like this: "DD/MM/AAAA" (Belgium).

If I insert a date into MS Word, the date is displayed properly. In Outlook (email dates or calendar appointments) dates are fine too.

But if I open an Excel file or create a new one, any date I enter in a cell is displayed like "DD-MM-AAAA". Since there is no way to set a default date format for Excel, I wonder how that can be??

Of course, I checked the cell format: Each date formats uses the "-" as a separator, even the format starting with a * (=format depending on the system defaults). If I want the cell to display my date format, I have to create a custom format.

I tried to change my system settings, start and close Excel, rechange the settings, but no effect. Into Word, when you click "insert date" there is "set default" button, I tried that too. Nothing. I searched on the Internet without a single result.

Any help would be appreciated.

Thanks,

Michal

Hi,

Try to change the system date format as DD-MM-YYYY. Then it will affect the date format in Excel.

Go to desktop, in the right down corner, click the date, then click "Change date and time settings...", then "Date and Time" dialog box will show, click "Change date and time" button, then click "Change calendar settings", change the date format in "Date Formats" part.

Hi, sorry for my late reply.

It didn't do the trick. Excel still displays the dates with a hyphen (-) instead of a slash (/) as a separator.

Same to me, excel 2013 wont use sytem settings!