Microsoft Excel 2016 Basic Course – Entering Date and Time in Excel – Video No. 12




About this tutorial:

Video duration: 5:24
Join us on Facebook:

Two Separators are used in Excel for dates. 1 is “/” and the 2nd is ‘-“. Both separators can be used. The date format can be changed from USA to UK by selecting the active cell then going to Home Tab, Number Format and then in Date Category select United Kingdom in the Location Field.

The short cut key for date is Ctrl+;

The Colon is used for Time. The Short cut key for Time is Ctrl+Shift+;

From 1930 to 1999, Excel will consider all dates as previous Century…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads