hihglight your date cells, click Format/Cells. Choose Custom in the list.
In the entry box below "Type" enter this without the quotes:
"dd\mm\yy"

"Trucci" wrote:

I set the date format with regional settings "Italy" how ever I still have to
enter date as mm/dd/yy while we are used to write it dd/mm/yy.
Did I did the wrong settings, even if I tried sevral european ones, or is
there something else to do so that I could finally insert a date in a way I
always did it?.
many thanks in advance