European date formats
 

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

The date 3 October 2005 is 38628 however it is displayed. If you are using
worksheets to collaborate across an ocean, by far the safest thing to do is
to use a "Universal" format. Pull-down:

Format Cells... Number Date 14-Mar-2001
(the last option). This format leaves no room for confusion.
--
Gary''s Student


"lynniemilano" wrote:

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