Date Formats

[Sammy]

I'm trying to change the date format from an American to
an Australian format. I've tried to change the format in
format/cells, but checking the AU option doesn't apply
the changes and the example doesn't change as well.

Any ideas?

Thanks in advance

 

[Norman Harker]

Hi Sammy!

Best may be to change your Regional Settings:

Start > Control Panel > Regional options
Change the country
Review the date forms offered
Apply

For a one off situation you can always pre-format with the Australian
date system by using Custom formats.

I believe that the setting of locale in Format > Cells only changes
the various options that are available. It doesn't change the default
for General format.


--
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.