Excel date issue

P

pduk

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

When I enter dates into excel as dd/mm/yy, excel does not recognise them as a date but if I enter mm/dd/yy then excel recognises it as a date. My system prerferences are set to Region: United Kingdom and dates as 05/01/2009 ie dd/mm/yyyy.
Is there another setting in Excel that I need to change in order for Excel to recognise dates as dd/mm/yy.
 
C

CyberTaz

Have you restarted Excel since changing your System Preferences? Excel can
only read them on launch.

Is Office fully updated? 12.1.7 is the current update level.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
P

pduk

Restarting Excel solved the issue. I recently updated to 12.1.7 and every time I update to a new version Excel seems to default at mm/dd/yyyy even though my system preferences do not change. However, it seems that after restarting Excel my system settings take effect.

Thanks
 

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

International Date Format 0
Date Formats 4
International Date Formats in Excel 4
Date Formats for Cells Do not match System Date Formats 5
Date entry not respecting my locale / Region 1
How to enter a date in DD-MM-YYYY format 2
British Date Formats 2
Edit Date 1

Top