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

T

Trucci

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
 
W

Wiley

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"
 
T

Trucci

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?
 
M

Marcelo

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 add day to PWA 2016 date format? 0
How to enter a date in DD-MM-YYYY format 2
Forcing a date entry format of dd/mm/yyyy 1
Date Format 10
change DD/MM/YY to MM/DD/YY 6
Got dates in dd/mm/yy, Excel refuses to understand this 1
Finding Date in an overseas format 21
Date dd-mm-yy(EXCEL) manipulation in VB macro 8

Top