Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Excel Report Date format problem?

My client sends me an automated spreadsheet with one column being date and time a ticket is created. The date is listed as Australians would do it (ie day before month) but excel does not recognize it as a date. So when I try to extract just the month or day, or to sort, it doesn't work.

If I try to format it as a date, if the day is less than 12 excel makes that the month, the rest it ignores. Even if I format it as Australian dates, excel switches them aroundHow do I tell excel this is a date written in Australian format and I do not want it changed.

2 Answers

Relevance
  • Anonymous
    1 year ago

    Have you tried under format for numbers for language changing it to English, Australian?

  • 1 year ago

    As you are receiving the workbook with the dates in Australian date format, you may need to set your regional settings to English UK, or to run a VBA routine adjust the cell formats to US date format.

Still have questions? Get your answers by asking now.