Excel quickly enters decimals. Two strokes make it easy to improve efficiency

When you input a large number of decimal places in an Excel XP worksheet, according to the normal input method, you usually input it directly according to the original size. For example, if you want to enter 0.05 in the cell, we will Enter "0.05" as is in the form. However, if you need to enter a number of numbers with a decimal point, and then input according to the above method, the work efficiency will be reduced. Today, Xiaobian teaches you two moves to improve office efficiency. Excel quickly enters decimals skills, and quickly go to it.

In the work, I have to enter a large number of data sheets with three decimal places. The data range is 0.001~100.000. Since most of the data sets are between 0.001 and 0.010, it takes 5 keystrokes to input a data, and the entry speed is relatively slow. Can you improve the input speed? After research, I found that by redefining the data format, the input efficiency can be greatly improved, such as input "0.001", just enter "1", the following is the specific implementation method and steps. :

Method 1: Automatically set the decimal point

1. Select the cell where you want to enter data;

2. On the <;Tools> menu, click &ldquo ;options", click “edit”tab;

3. Check the “automatically set decimal point” checkbox;

4. In “number of digits&rdquo In the box, enter the number of decimal places. In this example, enter “3”;

5. Click the “OK" button to start entering data.

Edit Tip: You can enter a positive number in the "digits" box, or you can enter a negative number. For example, if you type “3” in the “numbers" box and type “1” in the cell, the value is “0.001”. If you type “-3” in the "digits" box, then type “1” in the cell, then the value is “1000”; entered before selecting the “automatically set decimal point” The number is not affected by the number of decimal places.

Method 2: Custom Data Format

1. Select the cell where you want to enter data;

2. On the "Format" menu, click &ldquo ;cell”, select “number"tab;

3. Select “Customize”;

in the "Classification" drop down box 4. Click “Type” input box, enter the new format type "0.000,”, note that the comma“,” is a half-width English character, not a Chinese full-width punctuation;

5. Click “ Confirm the " button to start entering data. Previous12Next page Total 2 pages