If you've got a bunch of dates in US mm/dd/yyyy format and need to convert them into Australia's dd/mm/yyyy format (or vice-versa), it can be hard to know where to start. Office expert Helen Bradley details how you can work through that process in Excel.As Bradley notes, you can't simply apply a different date format to the data as this will either produce errors or convert dates into the wrong month (3/1/2011 is January 3 in Australia, but March 1 in the US). However, using Excel's Text to columns feature, you can reprocess the data to render correctly. Hit the post for the full details.
How To Convert Dates Between Australian & US Formats In Excel
Trending Stories Right Now
Since it launched in 2015, the Australian version of Netflix has been adding a steady stream of content each month. While the selection of movies and TV shows is getting better, it still pales in comparison to the US version due to national licencing deals. Here's how to get the whole US catalogue in Australia - without getting slugged by the exchange rate.
If you're an Android fan, there are a lot of great options when it comes to choosing a new handset. And three of the best we've looked at recently are the Google Pixel 3, Samsung Galaxy S10 and Huawei Mate20 Pro. We line them up side-by-side so you can compare and decide which is best for you.