how can I have Excel accept date in format dd/mm/yy ?

G

Guest

I set the date format with regional settings "Italy" how ever I still have to
enter date as mm/dd/yy while we are used to write it dd/mm/yy.
Did I did the wrong settings, even if I tried sevral european ones, or is
there something else to do so that I could finally insert a date in a way I
always did it?.
many thanks in advance
 
G

Guest

hihglight your date cells, click Format/Cells. Choose Custom in the list.
In the entry box below "Type" enter this without the quotes:
"dd\mm\yy"
 
G

Guest

Thank you wilwy.
i did as you told me but that does not change my problem as I would like the
date to show for ex 22-Jul-2006. That I can do by normal formating of the
cell even if I enter the date mm/dd/yy.
What I would like, if at all possible, is to make a default setting for
entering dates in the following way DD/MM/YY.
Is it possible? Do you know how to do it?
 
G

Guest

change it on the windows control panel not in excel

hth
regards from Brazil
Marcelo

"Trucci" escreveu:
 

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 to enter a date in DD-MM-YYYY format 2
change DD/MM/YY to MM/DD/YY 6
How do I change dates from dd/mm/yy to mm/dd/yy 2
Forcing a date entry format of dd/mm/yyyy 1
Need mm-dd-yy for date but helpless 2
dd/mm/yy format on textbox 10
Change date format in Excel footer 2
Change MM/DD/YYYY to MM/DD/YY 5

Top