Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get a free 3 hour Excel 2019 course from Simon Sez IT ️ https://www.simonsezit.com/four-free-courses

How Excel treats the number that you put into a cell will largely depend on how your device has been locally set up. In this video, you are going to learn how to enter and format data in Excel 2013, particularly date formats. Find out what is a long date and a short date, what the default date formats are in Excel 2013, and how to change the defaults. You will also learn how to format the data you've put in a selected cell.

Get the full course on Excel 2013 course here: https://www.simonsezit.com/course-category/excel/

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining5J
Google+: http://bit.ly/11JbHdb

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)

Hello again and welcome back to our course on Excel 2013. In this section, we’re going to continue looking at entering and editing data and in particular at some of the data formats that are available in Excel 2013. We’re going to continue with this straightforward sheet that we created in the previous section. We’ve got a couple of columns.

We’ve got Column B which has the description of some business expenses and Column C which has the actual amount of money spent. We’re now going to put a date on each of these expenses.

And the dates are going to go into Column A. Now the entry and editing of dates in Excel 2013 demonstrates a couple of very useful fundamental things and I want to spend a little bit of time on dates in this section. The first thing it demonstrates is that if you type part of a date into a cell, I’m actually going to use the Cell A2. So this is the date for the first expense in the list. What Excel thinks I’ve done will to some extent depend on the local setup of your device. Now I’m going to type 10/11. Now as you may appreciate it wouldn’t necessarily be the case that 10/11 is a date. 10/11 could be a fraction. It could be 10/11th’s of something. It could just be some sort of part code or other identification on an item.

But let’s see what happens. Having entered 10/11 if I now press the Enter key watch what happens. And what happens is that Excel treats that as the 11th of October. Now that’s because dates in my case are being handled in U.S. Date Format. In another part of the world with somebody using a different format such as the U.K. Format that would be treated as the 10th of November so 10/11 is the 10th of the 11th month. So, first of all, there’s a factor here related to locale and in order to understand that, we need to take a look in the Windows Control Panel.

In Windows 8 from Control Panel, if you click on Region then we see this dialog and within this dialog a couple of things. First of all, I’m going to just click quickly on the second tab which is Location. My location is United Kingdom but I can also set various aspects of how things are displayed according to another location. And the other location I’ve got is U.S. So if I go to Formats, the Format in which I basically display Dates and Times for that matter is English United States. Now there’s basically for dates, there’s a Short Date Format and a Long Date Format.

And there are examples of each based on the day that I’m recording this near the bottom of this tab of the dialog. The Short Date gives the month number which is 12, stroke, day number which is 3, stroke, year 2012. So that’s M/D/YYYY.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.