Enter and format number

In this lesson, you are going to learn how to enter the number and format it into your worksheet.

Enter and format the number

Click here for animated version

1. Type "1560" to cell B3 and press Enter key

enter number

2. Click Comma Style button, then number 1560 will be 1,560

enter number

4. Click format painter button

autofill data

5. Select cells B3 to G6, then the selected cells number format will be same as cell B3

autofill data

6. When the number been input to cells B4 to G6, the number will have a comma for every 3 digits.

autofill data

<< Auto fill month data | List of Excel Tutorials | Using autosum function >>

Top