Date Formats

  • Thread starter Thread starter Sammy
  • Start date Start date
S

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