I have changed in Control Panel the regional to Australia and cannot see in
Excel where to do this. In Word it is correct for spelling but in excel I
still get date as Month/Day/year NOT day/month/year as I would like.
Have gone to format and date and it shows only the USA style.
Mike

In the control panel regional settings you need to select customize,
then change the date system from there, if you just change to Australia
it will only change language rules, not the numeric settings.
Excel gets it date settings from the control panel


Regards,

Peo Sjoblom

MikeR-Oz wrote:
I have changed in Control Panel the regional to Australia and cannot see in
Excel where to do this. In Word it is correct for spelling but in excel I
still get date as Month/Day/year NOT day/month/year as I would like.
Have gone to format and date and it shows only the USA style.
Mike

Thanks PEO, but the customize area is correct. I have gotten around the issue
for the moment by using excel /format /custom/dd-mmm

Cheers
Mike

"Peo Sjoblom" wrote:

In the control panel regional settings you need to select customize,
then change the date system from there, if you just change to Australia
it will only change language rules, not the numeric settings.
Excel gets it date settings from the control panel


Regards,

Peo Sjoblom

MikeR-Oz wrote:
I have changed in Control Panel the regional to Australia and cannot see in
Excel where to do this. In Word it is correct for spelling but in excel I
still get date as Month/Day/year NOT day/month/year as I would like.
Have gone to format and date and it shows only the USA style.
Mike