Increase the Number of Decimal Places in Excel 2013


Excel’s default settings are perfectly fine in a lot of situations, but they can be difficult to work with if you have cells that contain large numbers, or numbers where multiple decimal places matter.

If your numbers are being rounded down or up, then this is likely due to an incorrect number of decimal places in your cell formatting. Fortunately you can increase the number of decimal places in your Excel 2013 cells to display as many numbers after the decimal point as you need.

 

Add More Decimal Spaces in Excel 2013

If you have number cells that are mixed in with letter cells, you can still choose to select them during the process below. Increasing the number of decimal places will not affect the contents of cells that contain letters.

If you increase the number of decimal places to an amount where they are not visible, then Excel will automatically expand the width of your columns to fit the extra numbers.

 

Step 1: Open your Excel spreadsheet that contains the number cells for which you want to increase the number of decimal places.

 

Step 2: Click the Home tab at the top of the window.

click the home tab

 

 

Step 3: Use your mouse to highlight all of the cells for which you want to increase the number of decimal places.

select the cells you want to adjust

 

 

Step 4: Click the Increase Decimal button in the Number section of the ribbon until your cells are displaying the desired number of decimal places.

how to increase the number of decimal places in excel 2013

 

 

Is there information that you would like to display at the top of every page, but you do not want to have to merge a bunch of cells to do it? Learn how to insert a header into your Excel 2013 spreadsheet.

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.