Explain excel cell format in detail

The chapter of Excel cell format will be divided into two articles. The first one is about the basic setting and function of Excel cell format. The second chapter explains the definition of Excel cell format. Many excel beginners think that the setting of Excel cell format is very weak, but the function of Excel cell is very powerful, so we can choose the appropriate one Suitable cell format will bring great convenience to our work.

believe that we have all encountered such a problem. Why did I enter the ID number into a mess? What? Why two people input the same content but display different results? In fact, they are all caused by different cell formats. To set the excel cell format, we must first select the data range to be set first, and then right-click to select the set cell format to set the cell format. You can also use the shortcut key Ctrl +1, as shown in the figure < / P > < p > the setting of Excel cell format I talked about is mainly about the explanation of various options under the number function, and the functions such as font alignment can be quickly set in the start menu, which is very simple, so I won’t talk about it. Next, I will explain the function of each option under the number function < / P > < p > conventional format: the conventional format is not included Data format with specific format, generally speaking, is what kind of data is input, what kind of data is displayed, it can automatically identify whether the input data is text or number, the text is left aligned, and the numerical value is aligned to the right. < / P > < p > numerical format: the number of digits after the decimal point can be selected after the cell is set to the numerical format, which is used to improve the calculation accuracy. Moreover, the number in the numerical format can be added, subtracted and multiplied by four operations, while the number in the text format can not be operated with four operations. There is also a display format for negative numbers to distinguish them from positive values. < / P > < p > accounting special format also uses currency symbol to express numbers. It is different from currency format in that currency symbol will be aligned to the right and numbers will be aligned to the left, which can be used to quickly set a column < / P > < p > date format: it is mainly used to set the date. Many people like to use points to divide the year and day. This input method is wrong. Excel can’t calculate it. There are two correct input methods: October 21, 2018 or October 21, 2018. Other input methods are wrong. When inputting data, never input numbers and Chinese characters together, which will cause huge trouble for later data statistics. Our common date display mode of Chinese characters with year, month and day can be generated by selecting the date format with year, month and day, without manual input < / P > < p > time format: used for time display format, you can set various display formats in options, and you can use it according to your own needs. The correct time input format is separated by colons, such as 12:10:12. Other input formats are wrong and cannot be recognized by Excel for calculation. Like the date format, we can see that the date display with Chinese characters can be realized by setting the cell format at 12:10:12, instead of the manually entered < / P > < P > percentage format: convert the numerical value to a percentage Add% sign after the data, and reserve two decimal places by default < / P > < p > fraction format: set the format of numerical value as fractional display, and display and select denominator. In the default state, if we input 1 / 4, excel will display January 4 by default. If it is set to the fractional format in advance, it will be displayed as 1 / 4 < / P > < p > scientific counting method: when a large number is encountered, it will be expressed in the form of power. When the value exceeds 15 digits, it will be automatically displayed by Excel using scientific counting method, and the ones after 15 digits will be omitted as 0, which is not often because of the loss of precision There is not much to do with the introduction. Here we need to mention that the default accuracy of Excel is 15 bits. That is why the last few of the ID number we entered after 15 bits will become 0.

text format: text includes letters, numbers, and symbols. When the cell format is set to text, the input is exactly the same as what is displayed. When we input the ID card and bank card number, we set the format as text in advance, and the scientific counting method will not appear after carriage return. Because the accuracy of Excel is only 15 bits, and the ones after 15 digits will be omitted to 0. When the cells are set to text format, there is a small green triangle in the upper left corner of each cell to prompt you that the cell format is text. What should be noted is that Text format can not be added, subtracted, multiplied and divided by four operations < / P > < p > the above is the meaning of each content in Excel cell settings, so what can he do? Let’s demonstrate the following several common settings < / P > < p > the basic setting of Excel cells is very simple. You can take a look at the options in each category, and choose the format setting you want to use However, the key is to see and practice more < / P > < p > the customization of cell format is the essence of Excel cell format. In the next chapter, we will learn about the customization of Excel cell format= https://twhosting.com/developed-a-plug-and-play-solar-power-generation-scheme-and-5b-won-a-12-million-round-a-financing/ target=_ blank>Developed a “plug and play” solar power generation scheme, and “5B” won a $12 million round a financing

Author: zmhuaxia