[Excel Practice 1] Input :: How to enter numbers, letters, dates, times, and double lines
Different ways to type
- As you may have noticed, it’s very easy to write in a cell.
- You just click and tap on the keyboard.
- We’re not here to tell you how to do that, so read on for some tips.
What you type will be separated by large letters, numbers, and dates.
- Speaking of which, as you type, you’ll see it sorted as follows.
- It is important to understand the following so that you can easily understand the cell formatting in the future.
- On the left, all the characters are recognized as letters
- On the right, dates are recognized as dates and numbers are recognized as numbers.
- You can tell by looking at the alignment: dates and numbers have a default alignment to the right, and letters to the left.
- The above should come naturally to you. “Wow, it recognizes dates as dates, numbers as numbers, and letters as letters!”.
I switched it to left alignment, so did it recognize it as a letter?
- No. 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.
So why do I need to know this?
- You’ll need it later when you learn about cell formatting.
- So being aware of it can make a big difference in your understanding of cell formatting.
- Let’s look at an example of cell formatting.
- The dates above all have the same value, 2023-01-01, in the date format.
- As long as I change it to the format I want, whatever date I type in there will be displayed in the format I specified.
- The day of the week will also be displayed automatically, but the cell formatting will be different next time… 😀
- If you write the date in text, you’ll always have to manually edit it.
- Let’s do it automatically, because our time is valuable. 😀
How to enter a date
- This is a trick that many people don’t realize.
- When you write today’s date, do you write 2023-01-21? If not, you don’t know this trick.
- Turn on Excel and experiment.
- 1-1?
- The intent of the input is to say January 1.
- The text comes out as January 1, and look at the image above. The date has been successfully entered as 2023-01-01.
- You want it to look like 2023-01-01? That’s for the next cell formatting time… XD
- Bottom line.
- When entering dates for the current year, you can write “month-date”.
- Adding
- Hours are entered using a colon (:).
- 2023-01-01 11:10
- 2023-01-01 23:10
Type two lines in one space
- Press Alt + Enter to enter two lines in one space.
- In the picture above, I tried to add a border with the application, which is often used in tables.
Pressing Alt + Enter doesn’t change anything.
- You need to select a cell and double-click it, or press F2 to press Alt + Enter while the cursor is blinking.