On the 'Products' worksheet, apply a number format to display the numbers in the 'Weight' column to three decimal places.

Question

Explanation

Explanation The instruction is to format the 'Weight' column which you want to apply the number formatting to. 2. Click Increase Decimal till the desired decimal places of three is selected, this is found on the Home tab.

OR

1. Select the cells in the 'Weight' column which you want to apply the number formatting to.
2. On the Home tab, in the Number group, click the arrow next to the list of number formats, then select More Number Formats.
3. In the Format Cells dialog box, on the Number tab, select Number in the Category list.
4. Enter the desired amount of decimal places you want to display in the Decimal places box, in this case it would be three.

References: https://support.office.com/en-us/article/Round-a-number-to-the-decimal-places-I-want-a9b36f9-6904-4250-AA98-02FF7B9A17B

No community discussion yet for this question.