You have to enter your dates in accordance with the regional settings
defined in windows. The format you defined is the one displayed, not
the one you enter.
Regards.
Daniel

All,


I have changed the date formatting of some cells through dd-mmm-yyyy, which
results in dates like 18-nov-2008, which is exactly what I am trying to
achieve.

However, the value of the cell is 11/18/2008, but I want to fill in
18/11/2008. Obviously, this should result in 18-nov-2008

Could someone tell me how to solve this?

Thanks in advance,