Today we are going to explore the different ways in which we can represent dates in Excel. Timestamps 00:00 Intro 00:30 Keyboard shortcut to input current date into a cell 01:11 Keyboard shortcut to input current time into a cell 01:34 Autofill dates 03:20 Short Date and Long Date from top menu 03:56 What to do if you see ####### in a cell 05:33 Built in date formats from the Format Cells dialogue box 07:25 Custom format dates 09:06 Sep-2022 format 09:49 Sep. 17, 2022 format 10:43 Convert general format to date format using Text to Columns 14:10 01-Jan-00 serial number 1 Learning Microsoft Excel RUclips playlist: ruclips.net/p/PLc... Excel challenge: ruclips.net/p/PLc... WeCanEduTech Pinterest: www.pinterest.com/wecanedutech/ WeCanEduTech Podcast: wecanedutech.podbean.com/ WeCanEduTech FB: facebook.com/WeCanEduTech
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Today we are going to explore the different ways in which we can represent dates in Excel.
Timestamps
00:00 Intro
00:30 Keyboard shortcut to input current date into a cell
01:11 Keyboard shortcut to input current time into a cell
01:34 Autofill dates
03:20 Short Date and Long Date from top menu
03:56 What to do if you see ####### in a cell
05:33 Built in date formats from the Format Cells dialogue box
07:25 Custom format dates
09:06 Sep-2022 format
09:49 Sep. 17, 2022 format
10:43 Convert general format to date format using Text to Columns
14:10 01-Jan-00 serial number 1
Learning Microsoft Excel RUclips playlist: ruclips.net/p/PLc...
Excel challenge: ruclips.net/p/PLc...
WeCanEduTech Pinterest: www.pinterest.com/wecanedutech/
WeCanEduTech Podcast: wecanedutech.podbean.com/
WeCanEduTech FB: facebook.com/WeCanEduTech