When you want to apply a minor tweak to the document, it must not take long to Alter date text. Such a basic action does not have to require extra training or running through handbooks to learn it. With the right document modifying instrument, you will not take more time than is necessary for such a swift change. Use DocHub to streamline your modifying process whether you are an experienced user or if it’s your first time using a web-based editor service. This instrument will take minutes or so to learn how to Alter date text. The only thing needed to get more productive with editing is actually a DocHub account.
A simple document editor like DocHub will help you optimize the amount of time you need to devote to document modifying no matter your previous knowledge of such instruments. Create an account now and boost your efficiency immediately with DocHub!
okay so over the past week in a bit weve been talking about different Excel date functions now were going to kind of combine our knowledge into a problem that a client of mine had where we essentially imported a bunch of data theres a whole ton of rows here and the date got imported from another program with a dot in between lets say the month the day and the year and what we want is we actually want to convert this to a date format because I want to be able to sort it properly I might want to be able to format the day these types of things so we talked about a function called date value and in some cases it would be as simple as saying date value of that cell and away we go problem is Excel does not recognize this as a date or as an acceptable date format thats just in text so we cant use date value date value just isnt going to work for this what I need to do is I need to use that function we talked about earlier as well called date and the date function I give it the three p