European Date Format

W

Will Sasser

How can you set the Date format in Excell to European. I
can change the Way it Reads (dd/mm/yy), but inputting it-
it has to be input mm/dd/yy?

Thanks,
Will Sasser
 
D

Dave Peterson

Try changing your windows regional settings to the order you like: dmy.

Windows Start button|Settings|Control panel|regional settings|Date tab
Modify your short date style.
 

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
How to enter a date in DD-MM-YYYY format 2
Date Format 10
Date Formats 4
Formatting 0
change DD/MM/YY to MM/DD/YY 6
how can I have Excel accept date in format dd/mm/yy ? 3

Top