SharePoint Document Issues

How to Fix SharePoint Lookup Value Displaying Trailing Zeros

Emma Brown Sep 27, 2026 869 views

Question details

SharePoint list lookup columns are displaying values with excessive trailing zeros (e.g., .000000000) instead of standard numerical formatting.

How to Fix SharePoint Lookup Value Displaying Trailing Zeros

Product: SharePoint
Device & OS: not provided
Scenario: Viewing or managing list data containing lookup columns in SharePoint.
Observed behavior: Lookup values appear as a number followed by a long string of zeros, which is typically caused by list configuration or client rendering behavior rather than changes to the source ID.

Before you start

Ensure you have Site Owner or List Administrator permissions to modify the Advanced Settings of the affected SharePoint list.

Solution 1Recommended

Disable Offline Client Availability

Turning off offline availability forces the list to render directly from the server, bypassing client-side caching glitches that cause number formatting anomalies.

This issue is often related to how SharePoint caches list data for offline synchronization. Disabling this feature forces standard server-side rendering, which typically resolves the trailing zeros glitch without modifying the actual data.

Navigate to List Settings

Open your SharePoint list, click the gear icon (Settings) in the top right corner of the screen, and select 'List settings' from the menu.

Open Advanced Settings

On the settings page, under the 'General Settings' category, click on the 'Advanced settings' link.

Disable Offline Availability

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

Save and Reload

Click 'OK' at the bottom of the page to save your changes. Return to your list and reload the webpage to verify if the lookup values now display correctly without trailing zeros.

Note on Offline Syncing: Disabling this setting means users will no longer be able to sync this specific list using the OneDrive sync app for offline access.

Solution 2

Request Administrator Assistance

If adjusting the offline list settings does not resolve the issue, the backend column configuration may require Microsoft 365 administrator intervention.

Free Microsoft Office alternative

Use WPS Office to Handle Exported SharePoint Data

If you frequently export SharePoint lists to spreadsheets for reporting, WPS Office serves as a lightweight, free Microsoft Office alternative. It offers full compatibility with Microsoft formats, ensuring seamless migration and a familiar user interface to format your data.

1. Download and Install: Visit the official WPS website to download the free, lightweight installer for your operating system.
2. Export SharePoint Data: In your SharePoint list, use the 'Export to Excel' or 'Export to CSV' function to download your raw data.
3. Open and Edit: Open the exported file directly in WPS Spreadsheet to seamlessly format numbers and remove any unwanted trailing zeros in your reports.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and CSV formats.Easily clean up and format exported SharePoint list data without trailing zeros.Free, lightweight, and features a familiar tabbed user interface.Built-in PDF tools and seamless cloud synchronization capabilities.

microsoft office alternative - wps office

Frequently Asked Questions

Why do SharePoint lookup columns suddenly display trailing zeros?

This is typically caused by a glitch in client-side rendering or the way SharePoint caches list data for offline use. It is almost always a display error rather than actual data corruption at the source ID level.

Does disabling Offline Client Availability delete my list data?

No, it only prevents users from syncing the list to their local device via OneDrive for offline access. All your list data remains safely stored and accessible on the SharePoint server.

Can I fix the trailing zeros using JSON column formatting?

Yes, as an alternative workaround, you or your site owner can apply custom JSON column formatting to strictly enforce a specific number format without decimal places, overriding the default client rendering.

Document & File Issues