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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
British Date Formats 2
Date Formats for Cells Do not match System Date Formats 5
Excel date issue 2
Date Formats 4
Date formats in ledger sheets 5
date format not working 1

Top