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
Current research shows that some of the most commonly used and seemingly positive phrases we use with kids are actually quite destructive. Despite our good intentions, these statements teach children to stop trusting their internal guidance system, to become deceptive, to do as little as possible, and to give up when things get hard.
I saw this open tin of stuffed vine leaves in our office fridge and immediately freaked out. I'd always been told that leaving food in an opened tin risked food poisoning, and I believed that. But then I realised I'd never bothered to question why this rule applied. Time to investigate.