SharePoint Document Issues

How to Fix SharePoint Number Column Displaying Decimals Incorrectly

Algirdas JasaitisAlgirdas Jasaitis Oct 21, 2026 870 views

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.

How to Fix SharePoint Number Column Displaying Decimals Incorrectly
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.
Before you start

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.

Solution 1Recommended

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.

1
Access Site Information

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.

2
Open Regional Settings

Under the 'Site Administration' section, click on 'Regional settings'.

3
Verify Locale

Check the 'Locale' dropdown and ensure it matches the geographical region that aligns with your preferred decimal separator format. Make changes if necessary.

4
Save and Refresh

Click 'OK' to save the settings, then navigate back to your list and refresh the page to see if the numbers display correctly.

Instant update: Changing the regional locale does not alter the backend data; it only updates how the data is rendered in your view.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install the free WPS Office suite from the official website.
  2. 2. Open Your Data: Export your SharePoint list to CSV or Excel, and open it effortlessly in WPS Spreadsheet.
  3. 3. Format with Precision: Highlight your number columns, right-click to select 'Format Cells', and accurately set your decimal places with real-time previews.
Fully compatible with Microsoft Excel file formats (.xlsx, .xls, .csv).Advanced, reliable number formatting and data validation tools to prevent rounding errors.Completely free, lightweight suite covering Word, Excel, PowerPoint, and PDF tasks.Familiar user interface for a zero learning curve when migrating from Office.
microsoft office alternative - wps office

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.