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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trucci - 21 Jul 2006 11:06 GMT

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

Reply to this Message

Wiley - 21 Jul 2006 20:22 GMT

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"

> 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

Reply to this Message

Trucci - 21 Jul 2006 21:49 GMT

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?

> hihglight your date cells, click Format/Cells. Choose Custom in the list.
> In the entry box below "Type" enter this without the quotes:
[quoted text clipped - 6 lines]
> > always did it?.
> > many thanks in advance

Reply to this Message

Marcelo - 21 Jul 2006 22:04 GMT

change it on the windows control panel not in excel

hth
regards from Brazil
Marcelo

> Thank you wilwy.
> i did as you told me but that does not change my problem as I would like the
[quoted text clipped - 14 lines]
> > > always did it?.
> > > many thanks in advance

Reply to this Message