Get a FREE 2.4 hour Excel 2019 Beginners course here ►https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/
During this Microsoft Excel 2016 training tutorial video, we will show you how to format dates entered on the workbook. You will learn how to change date and time settings according to your region, how to format dates in their short or long forms, how to work with dates that appear invalid in a cell, as well as how Excel interprets numbers entered in a cell as dates.
Checkout some of our other training on YouTube:
VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ
Excel 2016 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jUeMoLReqNzzuKj7rdLhZ2
Excel 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh
Access 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gbtcZ9Z3kbhk-2v65bfGeX
Project 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i1QJ6-Z91KRjFg5dzacD1O
Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF
SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge
PowerPoint 2013 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gX0kiJc3k8d31y0zTLcECq
Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)
Welcome back to our course on Excel 2016.
By now I hope you’ve completed Exercise 01 okay. In this section we’re going to carry on looking at entering and editing data. And in particular in this section I’m going to spend quite a bit of time looking at Date Formatting. Now dates are very often important in your worksheets and looking at the formatting of dates is actually a good way of finding out more at formatting data in Excel as well.
Now in order to demonstrate this I’m going to start by creating another new workbook. I’m going to put in this workbook details of some business expenses. Now for the moment I’m going to work near the middle of this worksheet. It doesn’t really matter where you work because you can always remove and add rows and columns later on a worksheet if you need to. But I’m going to type in one of the cells, let’s say M9 here, 3/9. Now what does 3/9 mean? Well if you were Microsoft Excel you might take a good guess at it. Perhaps it means 3/9, it’s a fraction. Perhaps it’s a part number, a part code of some sort. Or perhaps it’s a date. Depending on where you are in the world if it’s a date it could be March the 9th or it could be the 3rd of September. And when you’re dealing with dates local is very important. But it’s also important to understand that there are many different formats, many different ways in which people show dates.
Now in order to see what Excel makes of 3/9 let’s just click somewhere else. Let’s click in N9. And it’s taken it as the 9th of March. But notice I have 3/9. It thinks that’s the month number and then the day number. But it’s actually taking it as the 9th of March. So why has it done it that way round?
Now in order to see why dates come out on your device in the way that they do we need to look at something in Control Panel. So make sure that you can locate Control Panel on your Windows device. And then we need to look at the Region Setting. Now I’m telling you this now because whatever I’m doing in this section on dates may look quite different to you on your machine because you may have different settings to make. It doesn’t really make any difference to how the whole thing works in terms of Excel but it will make a difference to what you see in the workbooks, the worksheets that I’m showing you if you’re trying to work along with me.
Now the first thing is in this Region Dialogue my location is United Kingdom. But my formats are set to English (United States) formats. So for dates and times the formats I’m using are these and how various dates and times look in these formats, there are some examples of those in the lower part of this screen. So for instance my short date format is Month/Day/Year. So when I typed in 3/9 as an even shorter date Excel takes that as Month/Day and then when it displayed it back to me it displayed it back to me as 9-March. So it took the three as the month and the nine as the day. Now whatever happens on your device it’s going to be largely governed by your setting that you’ve got for the region on your device.
Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.