ExcelBanter - australian date format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - australian date format (https://www.excelbanter.com/excel-discussion-misc-queries/79301-australian-date-format.html)

Karline

australian date format

Hi there,
Evry time i enter a date the australian way it convertst it to the american
way how does one change this?

Bernard Liengme

australian date format

Change your Windows Regional Setting to Australia
Start Control Panel Regional Settings
best wishes from Canada on 23/03/2006
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Karline" wrote in message
...
Hi there,
Evry time i enter a date the australian way it convertst it to the
american
way how does one change this?

All times are GMT +1. The time now is 07:06 PM.