Calculation Issues

How to Stop Excel for Mac from Rounding Values When Reducing Decimals

Muhammad Talha Oct 14, 2026 869 views

Question details

The user needs to prevent Excel for Mac from permanently altering and rounding underlying stored values when adjusting the number of displayed decimal places.

How to Stop Excel for Mac from Rounding Values When Reducing Decimals

Product: Excel for Mac
Device & OS: Mac
Scenario: Adjusting the decimal display format of numeric data in an Excel spreadsheet.
Observed behavior: Instead of just changing the visual display, Excel is permanently rounding the actual stored values (e.g., changing 3.5 to 4).

Before you start

Check if you have a backup of your current spreadsheet, because any data that has already been permanently rounded by this setting cannot be automatically restored.

Solution 1Recommended

Disable the Precision as Displayed Setting

Turning off this calculation preference ensures Excel only alters the visual format without modifying the original precise data.

The 'Precision as displayed' feature forces Excel to permanently change stored values to match whatever appears on your screen. Disabling this is the only way to retain exact numeric values while displaying fewer decimal places.

Open Excel Preferences

Open Microsoft Excel on your Mac. Navigate to the top menu bar, click on 'Excel', and choose 'Preferences' from the dropdown.

Go to Calculation Settings

In the Preferences window, locate the 'Formulas and Lists' section and click on the 'Calculation' icon.

Clear Precision as Displayed

Look for the option labeled 'Precision as displayed'. Uncheck the box next to it to turn off the feature, then close the settings window.

Disable the Precision as Displayed Setting

Data Recovery Required: Values that were already rounded while this setting was active have been permanently changed. You will need to manually re-enter those specific numbers from your original data source.

WPS Spreadsheet Solution

Safely Format Decimals with WPS Spreadsheets

WPS Office provides robust and intuitive cell formatting options, allowing you to easily adjust displayed decimals without risking the integrity of your underlying data.

1. Open your file in WPS Office: Launch WPS Office on your device and open your spreadsheet document.
2. Select the target cells: Highlight the specific cells or columns where you want to adjust the decimal display.
3. Access cell formatting: Right-click the highlighted area and select 'Format Cells', then go to the 'Number' tab.
4. Adjust decimal places: Enter your desired number of decimal places. WPS Office will instantly update the visual layout while keeping your original precise values perfectly intact behind the scenes.

Safely format decimal appearances without permanently modifying your original precise values.Fully compatible with Microsoft Excel (.xlsx and .xls) file formats.Familiar user interface makes it incredibly easy to find and manage calculation settings.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel permanently alter my data when I decrease decimals?

By default, decreasing decimals only changes the visual format. However, if a setting called 'Precision as displayed' is enabled in your Excel Calculation preferences, the software forcibly changes the underlying saved values to perfectly match what is visible on the screen.

Can I undo the 'Precision as displayed' rounding effect on Mac?

No. Once 'Precision as displayed' is applied and the spreadsheet calculates, the original precise decimals are permanently erased from the document's memory. You must re-enter the data manually or restore from a previous file backup.

How do I safely change the number of decimal places?

First, ensure 'Precision as displayed' is completely unchecked in your Calculation settings. Once disabled, you can safely use the 'Increase Decimal' or 'Decrease Decimal' buttons on the Home ribbon to adjust appearances without altering the actual data.

Excel & Data Problems