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
Leave a Reply
You must be logged in to post a comment.