how do i cahnge the default date format?

[sokevin]

the current default date format is mm/dd/yy

how do i change the default to dd/mm/yy ?


i think its somewhere in my windows date settings.... but i cant see
to find where


thank

 

[Norman Harker]

Hi Sokevin!

Use:

Close Excel (not absolutely necessary but advisable)
Start > Settings > Control Panel > Regional Options

You can change date settings by changing your country but probably
better to click on the Date Tab and change there.

Windows XP route is a little different but you should be able to
figure it out from the above. If not, post back.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi
try
Windows Control Panel - Regional Settings - Dates
and choose your date format

 

[Norman Harker]

Hi Sokevin!

I forgot to add.

Don't forget to press "Apply" once you have made the changes. For some
strange reason they gave an OK button and that won't apply the changes
you make.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Gord Dibben]

sokevin

Start>Settings>Control Panel>Regional and Language Settings>Customize>Date

You may have to change the country setting also but have not played with that.

Gord Dibben Excel MVP

 

[sokevin]

thanks. i changed regional settings to australia.... works a trea
:cool

 

[GQC]

go to Control Panel / Regional and Language Options
gqc