When you want to apply a minor tweak to the document, it should not require much time to Location date form. Such a basic activity does not have to demand extra education or running through manuals to learn it. Using the right document modifying instrument, you will not take more time than is necessary for such a quick edit. Use DocHub to simplify your modifying process whether you are a skilled user or if it is the first time using an online editor service. This tool will take minutes to learn to Location date form. The only thing required to get more productive with editing is actually a DocHub account.
A simple document editor like DocHub will help you optimize the time you need to spend on document modifying irrespective of your previous knowledge about such tools. Make an account now and improve your productivity instantly with DocHub!
hey guys eddie the magic monk here as you can see i have a csv file called test data open in excel and in this file you can see that the dates are in the american format okay so here in australia we write dates as 2507 if its 25th of july but in america its 7 25 so i want to change this to match the australian or the international standard so this is what i would do okay i would get out of this csv file im going to create another one uh an excel file and im gonna call it date converted okay and im gonna open up this excel file and what im gonna do is im gonna go into the data menu and im going to click on from text csv and its in the section called get and transform data and what it does is it obtains the data from a csv file and transforms it before we put it in the spreadsheet so lets click on that and lets choose the folder from our desktop test data and you can see its uh detected the data and here the first column are the dates and forget the second column thats just