SharePoint Document Issues

Fix SharePoint Currency Column Adding an Extra Zero

Olivia Miller Sep 25, 2026 869 views

Question details

Users need to correct a formatting bug where a SharePoint currency column incorrectly multiplies inputted values by 10.

Fix SharePoint Currency Column Adding an Extra Zero

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Entering or viewing currency data within a SharePoint list that utilizes specific regional currency settings.
Observed behavior: The currency column automatically adds an extra zero to the inputted value (e.g., changing 1,240 to 12,400) due to offline caching or list-form formatting glitches.

Before you start

Verify that your site's regional settings match your intended currency format, and try viewing the SharePoint list in a private browsing window to see if the issue is merely a local display glitch.

Solution 1Recommended

Disable Offline Client Availability in List Settings

Turning off offline caching for the specific SharePoint list is the most effective workaround to stop currency values from saving incorrectly.

This issue is often caused by SharePoint's offline caching feature conflicting with specific regional currency formats (such as those used in Italy or other European regions). Disabling this feature forces the list to sync directly with the server without local caching modifications.

Navigate to List Settings

Open your affected SharePoint list. Click on the gear icon (Settings) in the top right corner and select 'List settings'.

Open Advanced Settings

Under the General Settings column, click on 'Advanced settings'.

Disable Offline Client Availability

Scroll down to the 'Offline Client Availability' section. Select the 'No' radio button to prevent the list from being downloaded to offline clients.

Save Changes

Scroll to the bottom of the page and click 'OK' to apply the settings. Enter a new currency value in your list to verify the issue is resolved.

Disable Offline Client Availability in List Settings

Workaround Confirmed: This method effectively stops the extra zero from being added while Microsoft investigates a permanent fix for the regional caching bug.

Solution 2

Clear Browser Cache and Test via Private Browsing

Clearing local browser data can resolve residual list-form formatting errors that persist after settings have been changed.

Free Microsoft Office alternative

Edit and Format Data Seamlessly with WPS Office

While web-based platforms like SharePoint can sometimes experience frustrating regional formatting and caching bugs, working with local spreadsheets shouldn't be a hassle. WPS Office provides a reliable, lightweight, and highly compatible desktop alternative to manage your financial data securely without unexpected formatting glitches.

1. Export Data from SharePoint: Export your SharePoint list to a CSV or Excel file to work on it locally.
2. Open in WPS Spreadsheet: Launch WPS Office and open your exported file.
3. Format Currency Accurately: Select your data columns, right-click, choose 'Format Cells', and apply the correct Currency format for your region.

Fully compatible with Microsoft Excel (.xlsx) and CSV formats exported from SharePointAccurate regional currency formatting that relies on stable local OS settingsLightweight application that opens instantly without heavy browser caching issuesFamiliar user interface for a zero-learning-curve transition

microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint automatically add an extra zero to my currency inputs?

This is a known bug related to SharePoint's offline caching feature conflicting with certain regional settings. When offline client availability is active, the list-form formatting can misinterpret the decimal or comma placement, effectively multiplying the number by ten.

Will disabling offline client availability affect other users on the SharePoint list?

Disabling this feature means that users will no longer be able to sync this specific list to their local devices for offline editing. However, it ensures data integrity for everyone entering currency values online.

Does changing the regional settings in SharePoint fix the currency bug?

Sometimes aligning the SharePoint site's regional settings with your local operating system's settings can prevent the conflict. However, turning off offline client availability is the most widely confirmed workaround for this specific extra-zero issue.

Document & File Issues