How can I change Excel 2003 to default to UK date format (dd/mm/yy) I've
tried re-installing, but I can get it to give me the option and have also
checked help on excel and tried everything esle i can think of!!

If i change the date format in the "format cells" option it gives me uk date
format but still assumes I am entering the date as an American!! so if I
enter the first of July as 01/07/06 it "corrects" this to 07/01/06, which it
then uses as the 7th of January.

any help would be greatly appriciated,

Thanks.

Nel post
*board-stupid* ha scritto:

How can I change Excel 2003 to default to UK date format (dd/mm/yy)
I've tried re-installing, but I can get it to give me the option and
have also checked help on excel and tried everything esle i can think
of!!

If i change the date format in the "format cells" option it gives me
uk date format but still assumes I am entering the date as an
American!! so if I enter the first of July as 01/07/06 it "corrects"
this to 07/01/06, which it then uses as the 7th of January.

any help would be greatly appriciated,

Thanks.


You have to change it from Windows Control Panel, International Options.

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Hi Franz,
I feel with you because of these silly translation difficulties (I use
Hungarian version), therefore I share with you this piece of information: the
original English term is Regional Settings.

Regards,
Stefi


€žFranz Verga€� ezt Ã*rta:

Nel post
*board-stupid* ha scritto:

How can I change Excel 2003 to default to UK date format (dd/mm/yy)
I've tried re-installing, but I can get it to give me the option and
have also checked help on excel and tried everything esle i can think
of!!

If i change the date format in the "format cells" option it gives me
uk date format but still assumes I am entering the date as an
American!! so if I enter the first of July as 01/07/06 it "corrects"
this to 07/01/06, which it then uses as the 7th of January.

any help would be greatly appriciated,

Thanks.


You have to change it from Windows Control Panel, International Options.

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Nel post
*Stefi* ha scritto:

Hi Franz,
I feel with you because of these silly translation difficulties (I use
Hungarian version), therefore I share with you this piece of
information: the original English term is Regional Settings.

Regards,
Stefi

Hi Stefi,

many thanks for the information.


--
Ciao

Franz Verga from Italy

Thanks guys - this was a big help :)

"Franz Verga" wrote:

Nel post
*Stefi* ha scritto:

Hi Franz,
I feel with you because of these silly translation difficulties (I use
Hungarian version), therefore I share with you this piece of
information: the original English term is Regional Settings.

Regards,
Stefi

Hi Stefi,

many thanks for the information.


--
Ciao

Franz Verga from Italy