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,