[Excel Practice 1] Input :: How to enter numbers, letters, dates, times, and double lines

[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.

Leave a Comment