By default, date is "MM/DD/YYYY" format in Excel. You can format a date to different styles, but the format in formula bar will not be changed.
– How to Enter a Number
– How to Enter a Fraction
– How to Enter a Time
– How to Enter Text Content
1. To Enter a Regular Date
Step 1. Select a cell and enter Month (e.g., 2);
Step 2. Enter slash;
Step 3. Enter Day (e.g., 12);
Step 4. Enter slash;
Step 5. Enter Year (e.g., 2011), you may need to format to a different style.
2. To Enter Today
When entering today's date, you can use either a shortcut or the TODAY function.
- Today Function
= TODAY ()
- Excel Shortcut
Ctrl+; (semicolon)
