format date

M

Maja_Hendrickx

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Hi,

Our excel uses the American way to write a date mm/dd/yyyy. Is there a way to put the date in a Europian way, dd/mm/yyyy?

Thanks,
Maja
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Hi,

Our excel uses the American way to write a date mm/dd/yyyy. Is there a way to
put the date in a Europian way, dd/mm/yyyy?

Thanks,
Maja
Click to expand...
Quit excel. Then change the date format in system preferences. Then restart
Excel.
 
Top