1. Entering Decimal Numbers:

• To enter a decimal number, simply type it with a decimal point (e.g., 3.14).

• Excel recognizes decimal numbers by default.

2. Formatting Decimal Places:

• To change the number of decimal places displayed:

  • Select the cell or cells containing the decimal numbers.

  • On the Home tab, in the Number group, you'll find the "Number Format" dropdown.

  • Click the dropdown and choose the number format you want. For example, you can select "Number" and then specify the number of decimal places you desire.

3. Performing Calculations with Decimal Numbers:

• Excel can handle decimal numbers in calculations just like whole numbers.

• Use standard operators (+, -, *, /) to perform arithmetic operations involving decimals.

4. Formatting Decimal Points for the Entire Worksheet:

• To set the number of decimal places for the entire worksheet:

  • Click on the "File" tab.

  • Go to Options > Advanced.

  • Under the "Editing options" section, find the "Automatically insert a decimal point" option. You can set the desired number of decimal places here.

5. Displaying Large Numbers:

• For very large or very small decimal numbers, you can use scientific notation. Format the cell as "Scientific" to display numbers like 3.14E+06 for 3.14 million.