When you need to apply a small tweak to the document, it should not require much time to Manipulate date text. Such a simple action does not have to demand additional training or running through manuals to understand it. Using the right document editing instrument, you will not spend more time than is needed for such a swift edit. Use DocHub to streamline your editing process regardless if you are a skilled user or if it’s the first time using an online editor service. This tool will require minutes to figure out how to Manipulate date text. The only thing needed to get more effective with editing is actually a DocHub profile.
A plain document editor like DocHub can help you optimize the time you need to dedicate to document editing no matter your previous knowledge of this kind of tools. Create an account now and enhance your productivity immediately with DocHub!
dates incorrectly formatted as text is one of the most common problems we face in excel so in this video im going to show you how easy it is to fix them using power query and the nice thing about this technique is it can be easily refreshed to pick up new dates be sure to watch to the end where i cover a date problem that comes up all the time when importing data from csv or text files that contain us formatted dates here ive got five common incorrect date formats now the problem with these dates is their text and excel cannot work with text dates in formulas or group them in pivot tables among other things there are a few ways we can tell these dates are text but one of the simplest is to use the keyboard shortcut the control key with the back quote symbol its typically found in the top left of your keyboard and it shares the same key as the tilde symbol this keyboard shortcut removes any formatting and it will show you formulas rather than their results and what were looking for