Enter the number 39768 in a few cells
Format each cell in a different date format and let us know if you still get
the same date format in all of them...
Also let us know what is the date you see.

"Totti" wrote:

Hi everyone,
There is something in my system other than regional settings that
doesnt allow me to read dates in the "mm.dd.yyyy" format, like even
if I try to enter such a format in the custom menu excel automatically
switches it back to "dd.mm.yyyy"
my regional settings are set to USA, even though i Live in Greece.
Any hints please?
Thanks in advance