Unusual file formats in your day-to-day document management and modifying operations can create instant confusion over how to modify them. You might need more than pre-installed computer software for effective and fast file modifying. If you need to bind date in dot or make any other simple alternation in your file, choose a document editor that has the features for you to work with ease. To deal with all the formats, such as dot, opting for an editor that actually works properly with all types of files is your best choice.
Try DocHub for effective file management, irrespective of your document’s format. It offers powerful online editing instruments that streamline your document management operations. You can easily create, edit, annotate, and share any file, as all you need to access these characteristics is an internet connection and an active DocHub profile. Just one document solution is everything required. Do not lose time jumping between different programs for different files.
Enjoy the efficiency of working with an instrument made specifically to streamline document processing. See how straightforward it really is to edit any file, even if it is the very first time you have worked with its format. Sign up an account now and improve your entire working process.
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