From the course: Learning Excel 2019
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Format dates and times - Microsoft Excel Tutorial
From the course: Learning Excel 2019
Format dates and times
- [Instructor] On occasion you may need to enter dates or even times into a sheet here in your Excel 2019 workbook, and in those cases, it's good to know they have their own formatting options, which we're going to explore with our leaf and mortar revenues workbook. You can open up LMRevenues0203 if you need to get caught up. Let's go to our title. Click in cell A1 and let's change it slightly, where it says leaf and mortar dash revenues. Click right in front of the "R" in revenues and type "projected" and leave a space. Press enter. And we've updated our title. Now we wanna put in the date that we projected these revenues. So in cell A2, if you're not already there, click there, and people type in dates different ways. You may like to use slashes or dashes. Maybe you do month, day, year and I do day, month, year. Or maybe you use words, letters. Let's just type in a date one way and see what happens. Let's say we wanna type in the first of November, 2018. Let's do it this way. Zero…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.