PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO INCREASE OR DECREASE DECIMAL PLACES IN EXCEL?

WHAT ARE DECIMAL PLACES IN EXCEL?

“DECIMAL PLACES IN EXCEL ARE THE NUMBER OF DIGITS AFTER ANY DECIMAL. FOR EXAMPLE 25.21452 IS HAVING 5 DECIMAL PLACES”

EXCEL GIVES US VERY EASY WAY TO INCREASE OR DECREASE DECIMAL PLACES BY JUST CLICKING A BUTTON.

 

 

WHEN TO INCREASE OR DECREASE DECIMAL PLACES IN EXCEL?

This is needed in many conditions. Few are listed below.

  • Different cells may be of different number type and it’ll have different number of places after decimal.
  • Any cell copied from other sheets or files may have different  number of decimal digits after zero.

    LOCATION OF DECIMAL INCREASE OR DECREASE BUTTONS

    The option for increasing or decreasing decimal places is located under the HOME TAB.

    increase or decrease decimal places
    LOCATION OF INCREASING OR DECREASING DECIMAL PLACES
    decimal places excel
    LOCATION OF INCREASING OR DECREASING DECIMAL PLACES

    The picture shows the location of buttons to increase or decrease decimal digits.

     
     

    STEPS TO INCREASE / DECREASE DECIMAL PLACES IN EXCEL

    STEPS:

    • Select the cell or all the cells where you want to change the number of digits after decimal.
    • Click on the increase or decrease button as per requirement.
    • Note that, if more than one cell is selected, all cells will be affected in the same way. (All cells will have same number of digits after decimal.
     

    Leave a Reply

    OTHER WAYS TO REACH THIS ARTICLE

    • INCREASE DECIMAL PLACES, DECREASE DECIMAL PLACES, INCREASE DECIMAL, DECREASE DECIMAL, SET NUMBER OF DIGITS AFTER DECIMAL IN EXCEL

    LEARN

    Encourage us by following at …

    If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

    [email protected]

    Share this:

    Like this:

    Like Loading...

    Pin It on Pinterest

    Share This

    KINDLY SPEND FEW SECONDS HERE....

    -We might be compensated for the visits or purchases you make by clicking the ads on this website .  They help us to keep bringing excellent quality articles for you.
    -Click on the pictures if you can’t read. All of them are High Resolution .
    -If you can’t find what you were looking for, kindly message in the chat box.
    *CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
    %d bloggers like this: