Distinguish between easily confusing text and values in Excel

Text data is descriptive and explanatory. Text data can be any character, so sometimes text and values may be confused. such as mobile phone numbers, bank accounts, although they are a string of numbers, but not used to calculate the value, but text.

When Excel identifies a long string of digits as a numeric value, if the cell is not wide enough, the number is automatically displayed in a scientific count format such as "1.39E+10." There are two ways to make it appear as a normal number, and the first is to liera the cell to the same width.

Width of the column where the cell is pulled

The second is to add an English single quotation mark to the number before the string.

Precede long string numbers with single quotes

With this example, we can basically learn how to change the name of a worksheet label, merge several cells, enter a date, tell Excel to use the input numbers as text processing, and adjust the unit Grekon and row heights. These knowledge and skills are often needed when entering data.