how do i cahnge the default date format?

  • Thread starter Thread starter sokevin
  • Start date Start date
S

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
 
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.
 
Hi
try
Windows Control Panel - Regional Settings - Dates
and choose your date format
 
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.
 
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
 
Back
Top