At work, the author often needs to enter a large number of data tables with three decimal places. The data range is 0.001 to 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 input speed is relatively slow. Can the input speed be improved?

At work, the author often needs to input a large number of data tables with three decimal places. The data range is 0.001 to 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 input speed is relatively slow. Can the input speed be improved? After research, the author found that the input efficiency can be greatly improved by redefining the data format. For example, if you enter “0.001”, you only need to enter “1”. The following are the specific implementation methods and steps:

Tips for Office Efficiency Excel Quickly Enter Decimal Skills

Method 1: Automatically set the decimal point

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

2. On the Tools menu, click Options, and then click the Edit tab;

3. Select the “Automatically set decimal point” checkbox;

4. In the “Digits” box, enter the number of decimal places, in this example, enter “3”;

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

Editing tip: You can enter a positive number or a negative number in the “Digits” box. For example, if you enter “3” in the Digits box, and then type “1” in the cell, its value is “0.001”. If you enter “-3” in the Digits box, and then type “1” in the cell, its value is “1000”; numbers entered before the Auto Decimal Point option is selected are not affected by the number of decimal places influences.

Method 2: Customize the data format

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

2. On the “Format” menu, click “Cell” and select the “Number” tab;

3. Select “Custom” in the “Category” drop-down box;

4. Click the “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;

Tips for Office Efficiency Excel Quickly Enter Decimal Skills

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

Editing tip: You can define the number of decimal places in the data by customizing the “type”, including commas in the number format, so that the commas can be displayed as thousands separators, or the number can be reduced by a thousand times. For example, for the number “1000”, it will be displayed as “1000” when it is defined as the type “#####”, and it will be displayed as “1” when it is defined as “#”.

It is not difficult to see that although the above two methods can achieve the same function, there are still some differences: the settings changed by using method 1 will be valid for all cells in the data table, while method 2 is only valid for selected cells. Using method 2, you can set different data formats for the data types of different cells. When using, users can choose different methods according to their own needs.

Recommended reading:

How to update  Yo WhatsApp 2022?

Where are the hidden chats in Yo WhatsApp?

Leave a Reply

Your email address will not be published. Required fields are marked *