It is important to understand the following so that you can easily understand the cell formatting in the future.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n <\/p>\r\n\r\n\r\n\r\n <\/figure>\r\n\r\n\r\n\r\n <\/p>\r\n\r\n\r\n\r\n
\r\nOn the left, all the characters are recognized as letters<\/li>\r\n\r\n\r\n\r\n On the right, dates are recognized as dates and numbers are recognized as numbers.<\/li>\r\n\r\n\r\n\r\n You can tell by looking at the alignment: dates and numbers have a default alignment to the right, and letters to the left.<\/li>\r\n\r\n\r\n\r\n The above should come naturally to you. “Wow, it recognizes dates as dates, numbers as numbers, and letters as letters!”.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n <\/p>\r\n\r\n\r\n\r\n
<\/span>I switched it to left alignment, so did it recognize it as a letter?<\/span><\/h2>\r\n\r\n\r\n\r\n\r\nNo. What I said above is that that’s the default alignment, but changing the alignment doesn’t turn numbers into letters and letters into numbers.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n <\/p>\r\n\r\n\r\n\r\n
<\/p>\r\n\r\n\r\n\r\n
<\/span>So why do I need to know this?<\/span><\/h2>\r\n\r\n\r\n\r\n\r\nYou’ll need it later when you learn about cell formatting.<\/li>\r\n\r\n\r\n\r\n So being aware of it can make a big difference in your understanding of cell formatting.<\/li>\r\n\r\n\r\n\r\n Let’s look at an example of cell formatting.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n <\/figure>\r\n\r\n\r\n\r\n\r\nThe dates above all have the same value<\/strong>, 2023-01-01, in the date format.<\/strong><\/li>\r\n\r\n\r\n\r\nAs long as I change it to the format I want, whatever date I type in there will be displayed in the format I specified.<\/span><\/li>\r\n\r\n\r\n\r\nThe day of the week will also be displayed automatically, but the cell formatting will be different next time\u2026 \ud83d\ude00<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n <\/p>\r\n\r\n\r\n\r\n
\r\nIf you write the date in text, you’ll always have to manually edit it.<\/li>\r\n\r\n\r\n\r\n Let’s do it automatically, because our time is valuable. \ud83d\ude00<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n <\/p>\r\n\r\n\r\n\r\n
<\/span>How to enter a date<\/span><\/h2>\r\n\r\n\r\n\r\n\r\nThis is a trick that many people don’t realize.<\/li>\r\n\r\n\r\n\r\n When you write today’s date, do you write 2023-01-21? If not, you don’t know this trick.<\/li>\r\n\r\n\r\n\r\n Turn on Excel and experiment.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n <\/figure>\r\n\r\n\r\n\r\n\r\n1-1?<\/li>\r\n\r\n\r\n\r\n The intent of the input is to say January 1.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n <\/figure>\r\n\r\n\r\n\r\n\r\nThe text comes out as January 1, and look at the image above. The date has been successfully entered as 2023-01-01.<\/li>\r\n\r\n\r\n\r\n You want it to look like 2023-01-01? That’s for the next cell formatting time\u2026 XD<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n <\/p>\r\n\r\n\r\n\r\n
\r\nBottom line.\r\n\r\nWhen entering dates for the current year, you can write “month-date”.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n\r\nAdding\r\n\r\nHours are entered using a colon (:).<\/li>\r\n\r\n\r\n\r\n 2023-01-01 11:10<\/li>\r\n\r\n\r\n\r\n 2023-01-01 23:10<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n <\/p>\r\n\r\n\r\n\r\n