Why do you enter formulas in excel and how do they become numbers

In excel, when you enter more than 11 digits, it will automatically turn to the way of scientific counting, such as typing: 123456789012345, and after entering, it becomes:, There are many ways to solve it, and now I have collected several for your reference:

1.Select the cell you want to enter numbers, click the right-click menu and select "Format Cell", or click "Format" to select "Cell".

Or press Ctrl+1), the cell format dialog box appears, click "Number" to select "Text" in the category, and press "OK", so that entering the number will not become a scientific counting method.

When entering numbers in unit A1, enter the 'number' in front of it, that is:'123456789012345, so that the cell will default to the text of the cell, and will display the 15 numbers in its entirety, instead of the annoying scientific counting method.

3.If you have entered a large number of numbers, all of them are displayed in scientific counts, and you are lazy to re-enter them one by one according to the above method, there is also this good method, such as having entered the number in unit A1:A100, select A1:

A10, right-click the mouse, select "Format Cells", the cell format dialog box appears, click "Number", select "Custom" in the category, enter "0" in the "Type", and it is easy to do.

4.There is also a way to solve it with a function: when a1:a100 has already entered a large number of numbers, enter :=text(a1,0) in unit b1 and the rest of the formula will be dropped.

5.Use data-disaggregation (see animation for details).

The above method only applies to 15 digits, and only two methods can be used for more than 15 digits.

Please refer to the animation tutorial in my post.

In the regular format, Excel will display numbers with more than 11 digits in scientific notation, such as when writing a 123456789012345678 in a cell.

This is the scientific notation expression, meaning:

Multiply by 10 to the power of 17.

When writing long strings of numbers in cells, you should pay attention to the following aspects.

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

2: In the conventional format, excel for the input of more than 11 digits of the number will be displayed in the expression of scientific counting, you can change the cell format to a special --- postal code --- determine, but only for the number within 12 digits of the number string is valid, more than 12 digits or set the cell format to the numeric format, the number of decimal places set to 0

Three: But even if the numeric format is set, if the number string is written more than 15 digits, because the numerical precision of excel is 15 bits, the part of the number string more than 15 digits will be filled with 0. Therefore, before entering a long string of numbers, the cells should be formatted as text.

Based on the above factors, the format of the cell should be set before writing a long string of numbers such as the ID number.

Here's how: Method 1. Select the cell or range of cells you want to enter the string of numbers--- right-click --- format the cells (you can also dot.)"Format"Select"Cells"

Or press CTRL+1, the Format Cells dialog box appears), -Number --- Text --- OK.

Method two. When a cell enters a string of numbers, enter it first.

number (single quotation marks in half width), e.g.

This way the cell will write the number in text format by default.

1. After entering a long string of numbers, I found that it automatically became a **formula with e+.

2. We right-click on the square where we entered the number, and then select Format Cell.

3. Then select the text in the pop-up box and click on the "OK" option.

4. Then we can see that no matter how long the number is entered, it will not become the form of e+, and the effect is as follows.

There could be several reasons for this:

1. The cell format is set to text format.

Workaround: Reactivate the cell by setting the Format Cells dialog box to General.

2. The calculation option of the formula has been changed to manual.

Solution: Set the calculation option of the formula to automatic.

3. The formula option is set to "Show Formula".

Solution: Deselect it.

In Excel, there are several reasons why numbers change:

Excel automatically changes the format of numbers: If you enter numbers that exceed the display limit of the cell itself, Excel may automatically change the format of the numbers, such as using scientific notation, rounding, and so on, which may cause the numbers to appear to change. To avoid this, you can format the cells as "numbers" or custom number formatting so that the numbers are displayed correctly.

Incorrect data entry: If you enter an incorrect number, such as forgetting to enter a decimal point, using a comma instead of a dot to separate decimal places, entering the wrong number, etc., these can cause the number to look different. Be careful to double-check before entering numbers.

Calculations of Excel functions and formulas: When you use functions and formulas in Excel for calculations, the numbers may change. For example, when executing certain functions, Excel may automatically round or truncate the numbers, resulting in a different result than the input comma.

To avoid this, you can try to calculate it manually, or use the appropriate formulas and formatting options so that you can get the right results.

Improper computer settings: When entering numbers, if your computer or Excel software is not set up properly, the numbers may change or cause errors. For example, issues such as incorrect date formatting, locales, and region inconsistencies can all cause the numbers to change.

Before using Excel, you can try to restore the default settings or check the language and time settings.

You can copy and paste it into numeric mode.

1. Take Excel2010 version as an example, open a ** with a formula, and now you need to convert the formula of C2 cell to a number;

2. First place the mouse on the C2 cell, and then press Ctrl+C to copy the cell, the dotted line around the cell means that the cell has been selected and is in the copy state;

3. Then right-click, select the second "123" value mode in the paste option, and click to select;

4. After clicking to get the value shown in the figure below, you will find that the formula of cell C2 has been converted to numbers;

5. If you want to convert multiple cells, select them together, then Ctrl+C to copy, right-click, and select the "123" value in the paste option;

6. You will see that the formulas of both cells in column C have been converted to numbers, and the conversion is successful.

It is because the cell spike is formatted incorrectly, and the solution is as follows.

1. Open the Excel** program and double-click to open it.

2. Then, in the Excel** program, click on the "File" option and click on Open.

3. Click "Format" in the drop-down menu, click the "Cell" option, and click Open.

4. Click the "Text" option in the window guess cheat port, and click OK.

5. Finally, you can enter the number in the cell and the problem is solved.

Excle, how do I display a formula as a specific number?

Excle, display the formula as a specific number, method Step 1 Select the area where you want to convert the formula result to a numeric value, here you can use the shortcut key, first click the first cell, and then use Ctrl+Shift+Down arrow. You can quickly select this one area. 2. Move the mouse to the edge of the cell, wait until the mouse becomes the shape shown in the picture, and hold the mouse and right-click.

Notice that it's holding down the right mouse button. 3. Hold down the mouse and right-click, drag the cell area outward, 4, and then drag the mouse to the original position, and release the mouse. In the pop-up menu, select "Copy Values Only"5 At this time, you will find that the formula for the cell no longer exists.

Only the result value of the formula exists.