Excel 2013 has a wide range of formatting choices that can be applied to cells in a worksheet. But some of the default formatting choices can be frustrating to deal with, especially when you need your numbers to display a certain way.
One characteristic that you might be dealing with involves numbers with a second decimal place where the number is a “0.” Excel will automatically stop that number from appearing, even if you have entered the number into the cell. Fortunately you can get Excel to stop removing this 0 in the second decimal place by switching a setting on the cell formatting menu.
How to Show Two Decimal Places Unconditionally in Excel 2013
The steps below are going to show you how to adjust the formatting for a group of cells in an Excel 2013 workbook. Only the cells that you select in the process below will display two digits behind the decimal point. If your numbers extend to three or more decimal places, Excel will round those values up or down. The full values will still be visible when you select the cell, but will only display as with two decimal places.
Step 1: Open a workbook in Excel 2013.
Step 2: Use your mouse to select the cells where you would like to display two decimal places. You can select an entire column by clicking the letter at the top of the sheet, an entire row by clicking the number at the left of the sheet, or you can select the entire sheet by clicking the cell above the row A heading, and to the left of the column 1 heading.
Step 3: Right-click a selected cell, then click the Format Cells option.
Step 3: Click the Number option under Category, enter “2” in the field to the right of Decimal places, then click the OK button at the bottom of the window.
All of the cells that you had selected should now display numbers with two places behind the decimal place.
Are you trying to print a spreadsheet from Excel 2013, but it is printing really small? Read this article and learn about options to adjust to make your spreadsheet print larger.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.