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

how can I have Excel accept date in format dd/mm/yy ? 3
How to enter a date in DD-MM-YYYY format 2
Date format 3
change DD/MM/YY to MM/DD/YY 6
Strange Julian Date Phenomenon 9
Preserving date format 1
Set Default Date to European Format without changing Regional settingof the PC 6
Finding Date in an overseas format 20

Top