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
There are currently four main streaming services in Australia: Netflix, Stan, Foxtel Now and Amazon Prime Video. There's also Apple TV+ and - in a few short days - Disney Plus. But that's not all. In addition to all of the above, there are smaller, more niche services like Hayu, 10 All Access and YouTube Premium - all of which contain original programming you can't watch anywhere else.
RCS messaging is here—thanks, Google—but there’s still a chance that you can’t flip the switch on it because, again, Google. Yes, it’s another feature rollout, which means you’ll be staring at your phone for some unknown amount of time, hoping it reveals to you the setting you can use to turn on something that sounds really awesome on paper.