How to change the number of decimal places in a selected number or numbers

1.  Select the range you want to format

2.  Click the ‘Home’ tab

3.  And click on the decrease decimal point command to decrease the amount of decimal places in your selected numbers. See the diagram below.

how to change the number of decimal points in a selected number

 

4. Or you can click on the increase decimal point command which is just to the left of the decrease decimal point command – to increase the amount of decimal places in your selected numbers.

 

Lesson 37: How to apply an Auto format to a Range

 

 

Submit a Comment

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