date setting

D

Des

I have set my regional settings to dd/mm/yyyy but when i put a date in excel
it insists onmm/dd/yyyy formatting the cell gives me options of 19/3/2005.
is there another setting to change. This seems very strange

Desmond.
 

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
Forcing a date entry format of dd/mm/yyyy 1
Publisher is filling blank lines with data 2
Date Formats 4
Date Format 10
Date Maniplation 1
How to enter a date in DD-MM-YYYY format 2

Top