1. Date and Time Data
When we input date and time data, we need to carefully check whether Excel has saved it correctly.
When Excel recognizes our data as a date or time, it automatically converts it to a specific format for display.
When Excel recognizes our data as a date or time, it automatically converts it to a specific format for display.
2. Default Date Format: Month/Day/Year
By default, Excel displays dates in the
When we input a date in the
Month/Day/Year format. When we input a date in the
Year/Month/Day or Month/Day/Year order, using - or / as separators, Excel can correctly recognize it as a date.3. Unrecognized Day/Month/Year Format
If the input date is in Day/Month/Year format, Excel will treat it as plain text;
Additionally, if the date separators are spaces or
Additionally, if the date separators are spaces or
., Excel will also not recognize it as a date.4. Input Date Without Year
By default, if a date is input without a year, Excel will interpret it as the current year's custom date format. Here, the date format is still month first, then day.
Note: If Month/Day recognition fails, Excel will attempt to recognize it as Month/Year.
Note: If Month/Day recognition fails, Excel will attempt to recognize it as Month/Year.
5. Time Segmented by Colons
To input time, use a colon
Note that Excel will automatically determine whether the time is AM or PM, and we can also specify whether it is AM or PM ourselves.
: as the separator for correct recognition by Excel. Note that Excel will automatically determine whether the time is AM or PM, and we can also specify whether it is AM or PM ourselves.
6. Month Abbreviations
Excel also supports recognizing abbreviated forms of months. For example:
Dec 2030 will be recognized as the custom date format Dec-30, with the value: 12/1/2030.7. Inputting Date and Time Simultaneously
When inputting date and time simultaneously, the above rules apply separately to the date and time parts.
Note that when inputting both date and time in a cell, there should be a space between the date and time.
Note that when inputting both date and time in a cell, there should be a space between the date and time.
8. 🎉 Finish! 🎉
Author's Note: I hope you can feel the effort I put into these tutorials. I hope to create a series of very easy-to-understand Excel tutorials.If it is useful, help me share these tutorials, thank you!
Follow me:
Related Tutorials