Question 1: How to format numbers in excel table 1 and select cells to format.

2. Click menu-"Cell" to pop up the cell setting box, then select and set the number format you want in the "Number" tab, and click OK.

As shown in the figure:

Question 2: How to set the number as three right keys in EXCEL table-custom cell format -SD-JY-000.

Question: How do the numbers entered in excel tables become formulas and how do they be set in a regular format? EXCEL will display numbers exceeding 1 1 digits in scientific notation. For example, if you write 1234595438+02345678 in the cell, 1.23457E+ will be displayed.

When writing a long number string in a cell, you should pay attention to the following aspects.

One: If a scientific counting expression is generated only because the column width of a cell is too small, you can change the display style by enlarging the column or setting the column width. For example, if the number written is more than 5 digits, the number is 1 1 and below, and the cell is too small, it will be displayed as a scientific counting expression.

Two: Under the normal format, EXCEL will display numbers exceeding 1 1 digits in scientific notation, and you can change the cell format to special-postal code -OK, but it is only valid for numbers within 12 digits. For numbers exceeding 12 digits, set the cell format as a number format and set the decimal places.

3: Even if the numeric format is set, if the written numeric string exceeds 15 bits, because the numerical precision of EXCEL is 15 bits, the part of the numeric string that exceeds 15 bits will be filled with 0. Therefore, before entering a long numeric string, you should set the cell format to text format.

Based on the above factors, the cell format should be set before writing the equal-length digit string of ID number.

The method is as follows:

Method one. Select the cell or cell range where you want to enter a numeric string-right click-set the cell format (you can also click the cell format or press CTRL+ 1 to open the cell format dialog box)-Number-Text-OK.

Method two. When entering a number string in a cell, first enter the' symbol (single quotation mark with a half angle), such as' 1234579 123456789, so that the cell will write numbers in text format by default.

Question: How does excel set the normal number format? If the number exceeds 12, the regular format will display the scientific count.

If it is lower than 15, you can directly modify the nail number format.

If it exceeds 15, first set the text format according to *** allcolour.

Question 5: Why can't numbers in excel tables be formatted? First, the numbers stored in text form are changed to non-text numbers. The method is as follows.

How to directly convert text into numerical values?

Method one

Select a cell-right-click to format the cell-change the text to normal format-and then enter the cell confirmation. If a large number of cells are in text format, it is not convenient to enter cells one by one for confirmation.

Method 2

Select an empty cell-right-click-Copy-and then select the cell and cell range where the text format is located-right-click-Paste Special-Add-OK. This is a method of adding 0 to the selected cell or cell range and making it a regular number through operation.

Method 3

Select the cell or range of cells where the text format value is located-an option icon will appear next to the selected cell or range of cells-click to open the options menu-and select Convert to Numbers.

Method 4

Select the column whose entire column is in text format-Data-Separate-Finish-Right-click again-Set the cell format as normal-OK.

Question: How can Excel tables increase the number of each cell by 50? It's simple. Don't make it complicated.

You enter 50 in a blank cell and copy it. Select the area (that is, the area where you want to add 50 to these numbers), right click → Paste Special, and select Add. The total has increased by 50 pounds.

Hero Online [email protected] (full account, no friends)

20 12 September 1

Question: How to add 1 to the figures in excel table? Set column a to normal format, and then

Enter a1:'170009032112.

Enter in A2:

=TEXT(A 1+ 1，0)

Pull-down filling

Question 8: When inputting numbers in excel tables, the numbers are far apart. How to set the regular score of 10? Suppose the number you say is written in column A, starting with cell A 1

Write the formula in cell B 1

=-substitution (A 1,,)

Drop-down copy formula or double-click fill handle.

Select column B again-right-click-copy-right-click again-paste selectively-get value-and delete the original column A after confirmation.

You mean this? If you don't explain your data style and the effect you want to achieve, you'd better take a photo.

Question 9: How to fill in the numbers in the Excel table in Excel? If the number exceeds 12 digits, the system will automatically convert it into scientific notation format. If the number exceeds 15, the system will automatically convert the number after 15 to "0". When we need to input some special values (such as ID number), this conversion can't meet our requirements. In order to display these long numbers completely, you must use the following two methods to convert cells into text format and then enter them.

Method 1: When entering these long values, first enter English single quotation marks ("'"), and then enter the values at the connectors.

Note: this method is suitable for inputting a small number of long values, and single quotation marks in English status will not affect the display and printing.

Method 2: Select the corresponding cell range, execute the Format → Cell command, open the cell format dialog box, select the text option under the value tab, and then enter a long value in the cell above.

Question 10: How to set the text in Excel equal to numbers? B 1=IF(A 1 for employees, 1500, IF(A 1= foreman, 2000, IF(A 1= supervisor, 3000,))