Start a conversation

How to convert American dates to Australian date format (MM/DD/YYYY to DD/MM/YYYY)

Sometimes iclass management systems used by Clubs only provide American dates (MM/DD/YYYY) which are not accepted by the Club Importer and will cause your import to fail.

Clubs can easily convert american dates to Australian format dates (DD/MM/YYYY) by following these steps:

  1. Highlight the column in excel with the american format dates (MM/DD/YYYY)
  2. Click on the Data header in excel
  3. In the Data ribbon, select 'Text to Columns'
  4. Click on the Next button
  5. Click on the Next button
  6. Change the selection from General to Date (see screenshot below)
  7. Change the Date format to MDY (see screenshot below)
  8. Click on Finish
  9. The dates will be converted to Australian Format (DD/MM/YYYY) and can be used in the club import

Need more help?  Contact us

Choose files or drag and drop files
Helpful?
Yes
No
  1. Marney Shepherd

  2. Posted
  3. Updated

Comments