How Do You Increase Decimal Points to Two in Word?
Learn how to change decimal points in Word tables that have been generated using formulas, either in Word directly or through Excel.
When you want to change the number of decimals for a number in Word 2013, usually you can simply insert the cursor behind the decimal point and type the numbers you need.
The process is more complicated when the value comes from a formula, either in a Word Table or a Table imported from Excel. To change the decimals in a formula, you need to open the Formula dialog box in Word, or change the decimals in Excel and bring the cells back into your Word document.
Changing Decimals in a Word Table
Highlight the cell containing the wrong number of decimals. Press Delete.
Click the Table Tools' Layout menu and select Data. From the drop-down menu click the Formula icon.
Click the Number Format menu. Select the appropriate option containing two decimal points. For ordinary numbers, use 0.00. For a percentage, use 0.00%. For currency use $#,##0.00.
Click the Formula menu and select the formula you used to calculate the cell the first time.
Examine the number to ensure it has the correct value.
Changing Decimals From Excel
Changing Excel Formulas in Word
Look at the number in the cell that you want to change. In this example of the average of two test results for Jenna and Jill, it's 76.
Click the Table Tools' Layout tab, select Data and then click Formula. Click the Number Format menu and select 0.00 for two decimals. Delete the default =SUM(ABOVE) formula and type the formula you used in Excel based on the cell locations in Word's table. In this example, the formula is =AVERAGE(B2,B3).
Click OK to close the Formula dialog box. Examine the new number to ensure it corresponds with what was there originally. In this example, 75.50 is correct. Rounded up, 75.5 would be 76, which is what the cell contained originally.
In an easy example like the one above, it may be easier to just to take out a calculator and manually change the number to 75.50, rather than changing the formula.
Changing Excel Decimals
Open the Excel worksheet containing the data that you need to change. Select the cell with the incorrect number of decimal points. Click the Home tab, then click the Increase Decimal Number icon until you have two decimal points.
Save the Excel worksheet if it's linked to a table in Word and then close Excel. Otherwise, highlight the cells that you need for the table and press Ctrl-C to copy them,
Open the Word document. If the Excel worksheet is linked to the table, it now shows the correct number of decimal points. If it's not linked, delete the table and press Ctrl-V to paste the copied Excel cells as a new table.
When a table in Word comes from an Excel spreadsheet, you can change the number of decimals in Word, or change them in Excel. If you pasted the cells into Word as a link, you should change the number of decimals in Excel. Word will update the cells as soon as you save the Excel workbook.
Regardless of how you pasted the data into Word, it's almost always easier to make the change in Excel and then paste the new contents into Word again. Changing the decimal places in Word's Function dialog box means manually changing the formula too.