australian

  1. D

    Can you change the windows regional settings to Australian with a macro?

    Is it possible to change the regional settings in windows to Australian with a macro? I need to know as I can build that into my spreadsheet as the users might not know how to change it manually.
  2. D

    What is the VBA to convert a cell to the Australian date format

    What is the VBA to convert a cell to the Australian date format of dd/mm/yyyy?
  3. G

    American vs Australian Date Format Issue

    Hi there I export dates from a program, which generates the dates in a mm/dd/yyyy format. Problem is I'm in Australia and need it to be dd/mm/yyyy. I cannot change the export settings. Is there a way I can convert the dates with a formula or similar? The problem I have is some dates end up...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top