I received an Excel spreadsheet from an Italian colleague but the formulas
aren't working properly because although I can input dates in dd-mm-yy format
they are displayed in mm-dd-yy format even when I choose the Italian format
from the menu, i.e. October 10th is saved as 03-10-05 but is displayed as
10-03-05.

Anyone have any ideas how I can fix this?

thanks,

Lynn