Unusual file formats in your everyday papers management and modifying processes can create instant confusion over how to edit them. You may need more than pre-installed computer software for efficient and speedy file modifying. If you want to set date in xls or make any other basic alternation in your file, choose a document editor that has the features for you to deal with ease. To deal with all the formats, such as xls, choosing an editor that actually works well with all kinds of files will be your best choice.
Try DocHub for effective file management, irrespective of your document’s format. It has powerful online editing tools that simplify your papers management operations. You can easily create, edit, annotate, and share any file, as all you need to access these features is an internet connection and an functioning DocHub profile. Just one document tool is all you need. Do not lose time switching between various applications for different files.
Enjoy the efficiency of working with a tool created specifically to simplify papers processing. See how easy it is to revise any file, even if it is the very first time you have dealt with its format. Register a free account now and improve your whole working process.
hey guys welcome back to my channel in my tutorial in this particular video Im going to teach you how to format bed in a particular way but sometimes when you are when you try to format the date using the format cells option even though when you select the date column here date here format is not going to change because rate format in this particular scenario is in a text format and Excel is not going to identify this as a date range so all we need to do is we need to go to the data tab click on text to columns make sure delimited is selected click on next click on next again so in this particular dialog box here click on bed and you can select as mdy and click on finish so basically this will convert the text format into the date format and Im going to press the control one button to get the format cells dialog box and you can change the format here based on your requirement so lets say I just want this to be formatted in month and year format so Im going to type in mmm - YY YY c