When you edit files in different formats day-to-day, the universality of the document solution matters a lot. If your tools work with only some of the popular formats, you may find yourself switching between application windows to change state in csv and manage other document formats. If you wish to get rid of the hassle of document editing, get a solution that can easily manage any format.
With DocHub, you do not need to focus on anything but actual document editing. You will not need to juggle programs to work with different formats. It can help you edit your csv as easily as any other format. Create csv documents, modify, and share them in one online editing solution that saves you time and boosts your productivity. All you need to do is sign up a free account at DocHub, which takes just a few minutes or so.
You will not need to become an editing multitasker with DocHub. Its feature set is enough for speedy papers editing, regardless of the format you want to revise. Begin with creating a free account to see how straightforward document management can be having a tool designed particularly to suit your needs.
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