How can you format a range of cells with decimal places?
Answers
Answered by
4
Answer:
Formatting a range of cells with decimal places:
The division of different numbers may result in varied decimal places in the quotient. In such cases
it is necessary to format the number to a fixed number of decimal places.
1. Font Apply different font types on a worksheet.
2. Font Size Apply different font sizes on a worksheet.
3. Bold Make the selected text bold.
4. Italic Italicize the selected text
5. Underline Underline the selected text.
6. Left Alignment Align text in a cell to the left.
7. Center Alignment Align text in a cell to the center.
8. Right Alignment Align text in a cell to the right.
9. Increase decimal places Show more precise value by showing more decimal places.
10. Decreased decimal places.
Answered by
59
Number formats in Excel
- Select a cell or a cell range.
- On the Home tab, select Number from the drop-down. Or, you can choose one of these options: Press CTRL + 1 and select Number. Right-click the cell or cell range, select Format Cells and select Number.
- Select the format you want.
Similar questions