0
You can use almost any format you like to enter the date. The key to using and viewing dates is the cell format. Right-click on the cel and select cell format. Then you can format the date to look almost any way you like.
Wiki User
∙ 14y ago
Wiki User
∙ 8y agoYou can type the date in and the time in, using slashes to separate the dates and colons to separate the time, like this:
02/05/87
12:15
Using the Ctrl - ; combination, you can put in the current date. Using Ctrl - : you can put in the current time.
You can use the DATE function to construct a date with the year, month and day elements and the TIME function from the different hour, minute and second elements:
=DATE(1938,12,5)
=TIME(3,15,28)
Wiki User
∙ 14y agoUse the built in Help (F1 key) ask the question there!
Add your answer:
Earn +20 pts
When you enter a date excel assigns a what value to the date?
numerical
When you enter a date Excel assigns a?
a serial value to the date
MS Excel and MS Office?
MS excel is a part of MS Office suite. You can create spreadsheet with the help of MS excel.
Why is MS Excel is called Excel?
MS-Excel is a powerful worksheet & you calculate , syncronize many hard calculation, so MS-Excel is called Excel.
Where is MS Excel?
MS Excel is under Microsoft Office
What is the meaning of ms Excel 2010?
ms excel 2010
How many cells in ms-Excel?
16,777,216 in versions up to MS Excel 2003. From MS Excel 2007 onwards is 17,179,869,184.
Where is the Excel located on the computer?
Program - MS Office - MS Excel
Why MS-Excel is used?
ms excel is used to create spreadsheets.
How can you show the MS Excel ruler bar?
There is no ruler bar in MS Excel. That is an MS Word function.
What is the cursor on ms Excel is called the?
The cursor is called a cursor in MS Excel.
What is an excel function used to enter the system date in a cell in a worksheet?
The NOW function
