How to Fix SharePoint Number Column Displaying Decimals Incorrectly
Question details
The user needs to fix a SharePoint Number column that incorrectly displays a decimal number (like 3.5) as a whole number (35) instead of properly rounding it to 4 when configured to zero decimal places.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Configuring a Number column with zero decimal places in a SharePoint list on a Teams-connected site.
- Observed behavior
- The number 3.5 is displayed as 35 instead of rounding to 4. The issue persists across all newly created lists on the affected site, while the same setup works perfectly on other sites.
Ensure you have site owner or administrator permissions for the affected SharePoint site, as you will need access to modify regional settings and list configurations.
Verify Site Regional Settings and Locale
Incorrect regional settings can cause decimal separators to be misinterpreted by the system, leading to display errors in number columns.
Different regions use different symbols for decimal separators (e.g., a period in the US, a comma in parts of Europe). If the site's locale is mismatched with your input format, SharePoint may ignore the decimal point entirely.
Click the gear icon in the top right corner of your SharePoint site and select 'Site information', then click 'View all site settings' at the bottom.
Under the 'Site Administration' section, click on 'Regional settings'.
Check the 'Locale' dropdown and ensure it matches the geographical region that aligns with your preferred decimal separator format. Make changes if necessary.
Click 'OK' to save the settings, then navigate back to your list and refresh the page to see if the numbers display correctly.
Check Column Settings and Remove JSON Formatting
Custom column formatting or incorrectly defined column types can override standard rounding rules and cause display glitches.
Submit a Support Request via Microsoft 365 Admin Center
If the issue affects all new lists on the specific site despite correct settings, it indicates a potential backend configuration error that requires Microsoft support.
Manage Your Spreadsheets Seamlessly with WPS Office
While SharePoint backend issues often require administrative support to resolve, managing your data locally shouldn't be a hassle. WPS Office provides a lightweight, fast, and highly reliable alternative for organizing, formatting, and analyzing your spreadsheets without unexpected decimal glitches.
- 1. Install WPS Office: Download and install the free WPS Office suite from the official website.
- 2. Open Your Data: Export your SharePoint list to CSV or Excel, and open it effortlessly in WPS Spreadsheet.
- 3. Format with Precision: Highlight your number columns, right-click to select 'Format Cells', and accurately set your decimal places with real-time previews.

Frequently Asked Questions
Why does SharePoint display a decimal number like 3.5 as 35?
This generally happens due to a mismatch in regional settings. If the SharePoint site's locale expects a comma as the decimal separator but receives a period (or vice versa), the system fails to recognize the separator and visually concatenates the digits into a whole number.
Can JSON column formatting alter how numbers round in SharePoint?
Yes. Custom JSON formatting overrides default column settings. If the JSON code incorrectly parses the numeric value or lacks the proper rendering parameters, it can cause unintended visual outputs like dropping decimal points or failing to round.
How do I change the decimal separator format in a specific SharePoint site?
You can change the expected decimal separator by adjusting the site locale. Navigate to Site settings > Regional settings, and select a locale that aligns with your preferred number formatting rules.
Will fixing the column format retroactively fix existing list items?
Yes. Modifying the display settings or regional locale changes how the number is rendered in the list view dynamically. Because the raw data stored in the backend (e.g., 3.5) remains unaffected, updating the view will correct the appearance of all existing items.




