How to perform data entry of date-time
Now we will see that how we can perform data entry of date and time in MS Excel.
Date and time are very important feature to complete any data entry.
Firstly we will use '/' to enter date, that is when we want to enter any date we can write it as '16/10/2016'. Or else also '16/10/16', it will get directly changed to '16/10/2016'.
We can also use '-' to enter date, like '16-10-2016'.
If by mistake we have added any wrong date then it will be left aligned in MS Excel.
To manipulate date we have many functions in FORMULAS tab inside Date & Time option.
Similarly if we want to enter time we will use ':' symbol. Like - '2.30' , and if we want to show our time in 24 hour format then also we can write it as '14.30'. It is also correct.
If we are working in any Excel sheet which requires previous year data, then we have to enter the date manually because MS Excel has restricted the date at particular time period.
Overall date and time can be entered in Microsoft Excel by using '/' and ':' symbols.
Share a personalized message with your friends.