why does excel keep rounding my numbers

Question

why does excel keep rounding my numbers? how do i get it to stop

Answer 1

Hello, Bacilia Herrera

Welcome to the Microsoft community.

Thank you for your feedback. In Excel, if you find that numbers are being rounded automatically, it's usually because the cell's formatting settings are limiting the number of decimal places. Here are ways to fix this problem:

Method 1:

Select cells or range: click on the cell or select a group of cells you want to adjust.

Right-click the selected cells, and then select “Set Cell Format”.

In the pop-up dialog box, select the “Digital” tab.

Select the “Numeric” category, and then adjust the “Decimal places” to the number of places you need.

Click “OK” to save changes.

Method 2:

Select the cell or range: Click on the cell you want to adjust or select a group of cells.

In Excel's “Home” tab, find the “Numbers” group.

Click on the button to increase the number of decimal places (usually displayed as an icon with more digits after the decimal point) until the number of decimal places you need is displayed.

Method 3:

Click the “File” menu in the upper left corner, and then select “Options”.

In the Options dialog box, select Advanced.

Scroll down to the “When calculating this workbook” section and make sure “Set precision to displayed precision” is unchecked.

Click OK to save the changes.

I look forward to your feedback.

Best Regards,

Aaron| Microsoft Community Support Specialist

Answer 2

Hi, Bacilia Herrera

thank you for your question!

Excel might be rounding your numbers because the cell format is set to display a limited number of decimal places. 

Here's how you can adjust it:

1.Select the affected cell or column.

2. Right-click and choose Format Cells.

3. Go to the Number tab.

4. Choose either Number or General. When selecting General, Excel will display the number as you entered it, without rounding, but without specifying the number of decimal places.

5. If you want more control over decimal places, choose Number and adjust the Decimal places to show the exact precision you need.

If this doesn't fully resolve your issue, feel free to ask for more help. I’m happy to assist further!

Best regards,

John Smith Tech