Fix SharePoint Changing Long Number Values Precision Limits
Question details
Users experience an issue where SharePoint alters or rounds long numeric values imported from Microsoft Forms or spreadsheets.
- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Importing exact numeric data, such as tracking numbers or identifiers, from Microsoft Forms or spreadsheets into a SharePoint list.
- Observed behavior
- Long numbers exceeding precision limits (e.g., 1234909113691633) are altered or rounded down and stored incorrectly (e.g., as 1234909113691630).
Verify whether the long numeric values being imported are meant for mathematical calculations or serve as exact text identifiers.
Store Long Numbers in a Single Line of Text Column
Change the data type from Number to Single line of text to prevent SharePoint from applying numeric precision limits during import.
SharePoint has a strict limit on numeric precision. When numbers exceed 15 digits, they are mathematically rounded down or altered to fit this limit. By storing identifiers or long reference numbers as text, you bypass this mathematical limitation entirely and preserve the exact input sequence.
Open your SharePoint list, click the gear icon (Settings) in the top right corner of the page, and select 'List settings'.
Scroll down to the Columns section and click on the name of the Number column that is altering your values.
Under 'The type of information in this column is', select the radio button for 'Single line of text', then click 'OK' at the bottom to save the configuration.
Because the existing values have already been rounded, delete the incorrect records and reimport the original data from your Microsoft Forms or spreadsheet source.
Manage and Format Spreadsheet Data Effectively with WPS Office
While SharePoint lists have strict formatting limitations, managing and formatting your raw spreadsheet data before uploading is easier with a flexible alternative. WPS Office provides a lightweight, highly compatible, and free office suite to manage large datasets and format long numbers as text securely.
- 1. Open Your Data in WPS Spreadsheet: Launch WPS Office and open the spreadsheet containing your long numeric values.
- 2. Format Cells as Text: Highlight the column with the long numbers, right-click, select 'Format Cells', choose the 'Text' category, and click 'OK'.
- 3. Save and Prepare for Import: Save your document as an .xlsx file. The numbers are now locked as text strings and ready for safe import into SharePoint.
Frequently Asked Questions
What is the maximum number of digits SharePoint can store accurately?
SharePoint Number columns typically support up to 15 digits of precision. Any number longer than 15 digits will be automatically rounded or padded with zeros.
How can I fix data that has already been rounded by SharePoint?
You cannot recover the exact lost digits directly within SharePoint once they are rounded. You must change the column type to 'Single line of text' and reimport the original, unrounded data from your source file.
Will changing a Number column to Text affect my existing SharePoint data?
Changing the column type will retain the existing displayed values, but any numbers that were already corrupted by precision limits will remain corrupted until manually updated or reimported.
Can I perform mathematical calculations on text columns in SharePoint?
No. Once a column is formatted as a Single line of text, you cannot use mathematical functions like SUM or AVERAGE on it. Text columns should only be used for identifiers, references, or codes.
