Enter a Date : Value Input « Editing « Microsoft Office Excel 2007 Tutorial






Click a Cell. Type the date using a slash (/) between the month, day, and year. Press Enter.
Click a Cell. Type the date using a slash (/) between the month, day, and year. Press Enter.
Or Type a hyphen (-) between the month, day, and year. Press Enter.
Or Type a hyphen (-) between the month, day, and year. Press Enter.
Check the Result
Result








2.16.Value Input
2.16.1.Enter a Text LabelEnter a Text Label
2.16.2.Enter a Number as a LabelEnter a Number as a Label
2.16.3.Entering Values on a WorksheetEntering Values on a Worksheet
2.16.4.Enter a DateEnter a Date
2.16.5.Enter a Time on a 12-hour clockEnter a Time on a 12-hour clock