If you edit files in different formats day-to-day, the universality of your document tools matters a lot. If your instruments work with only some of the popular formats, you may find yourself switching between software windows to revise date in dot and manage other document formats. If you wish to take away the hassle of document editing, go for a solution that can easily handle any format.
With DocHub, you do not need to concentrate on anything short of the actual document editing. You won’t have to juggle programs to work with diverse formats. It can help you revise your dot as easily as any other format. Create dot documents, edit, and share them in one online editing solution that saves you time and improves your productivity. All you need to do is sign up an account at DocHub, which takes just a few minutes or so.
You won’t have to become an editing multitasker with DocHub. Its functionality is enough for fast document editing, regardless of the format you want to revise. Begin with creating an account and see how easy document management may be having a tool designed specifically for your needs.
hello everyone welcome to my channel excel sessions and today we will learn how to use string functions and date functions to change the dates mentioned in any format now in this sheet i have dates in two different formats which is not recognized by excel as date now if you select the date and press ctrl 1 and select date in category and select any type and press ok the text in cell a2 will not change in the date format now in such scenarios we shall use date and string function together to change the text in date format type is equal to date open bracket date function takes three parameter the first parameter is year in cell a2 the year is last four digits so type write open bracket select cell a2 comma four closing bracket comma the next parameter is month which is two digits after first dot in cell a2 so type mid open bracket select a2 comma starting position is 4 comma 2 closing bracket comma the third parameter is the day which is first two characters in cell a2 so type left open