How to Fix Microsoft Forms Dropping Digits from Submitted Numbers
Question details
Users report that Microsoft Forms intermittently removes digits from multi-digit numeric responses, particularly when submitted via Android devices.
- Product
- Microsoft Forms
- Device & OS
- Android
- Scenario
- Collecting numeric data using Microsoft Forms.
- Observed behavior
- Multi-digit numbers entered by respondents are truncated or have digits missing upon submission (e.g., '253' becomes '25').
Ensure you have access to the form's response data and a test device to try and replicate the issue before making any changes to your live form.
Diagnose the Issue and Contact Microsoft Support
Since this is a known intermittent bug with Microsoft Forms, gather diagnostic information and escalate it to official support.
This issue is not caused by reaching the response limit. Business accounts support up to 5,000,000 responses, so hitting 5,000 responses is not the root cause. The most effective approach is to isolate the variables and contact Microsoft support.
Duplicate your existing form from the Microsoft Forms dashboard to safely run tests without affecting your live data collection.
Attempt to replicate the digit-dropping issue using different Android devices, browsers, and network connections.
Document the form URL, exact timestamps of incorrect submissions, device models, Android versions, and browser types used by affected respondents.
Open a support ticket within the Microsoft 365 Admin Center, providing all collected evidence and examples of the truncated responses.
Use Text Fields with Custom Validation
As a temporary workaround, switch numeric inputs to text fields with validation to prevent the system from truncating number formatting.
Try WPS Office for Reliable Data Collection and Document Management
If you are experiencing persistent bugs with Microsoft Forms or Office tools, consider switching to WPS Office. It offers a comprehensive, lightweight suite of tools with robust spreadsheet capabilities and seamless compatibility with Microsoft Excel, ensuring your data is analyzed accurately without missing digits.
- 1. Download WPS Office: Visit the official WPS website to download and install the free all-in-one office suite.
- 2. Import Your Data: Open WPS Spreadsheets and easily import your exported .xlsx data to manage your form responses accurately.
- 3. Analyze Without Errors: Use built-in functions, pivot tables, and formatting tools to analyze your data safely and reliably.
Frequently Asked Questions
Does the Microsoft Forms 5,000 response limit cause digits to drop?
No. The response limit for business accounts is significantly higher (up to 5,000,000 responses). This digit-dropping issue is a known intermittent bug with mobile rendering, not a capacity limitation.
Why does Microsoft Forms mainly drop digits on Android devices?
While the exact root cause is a backend bug, it frequently occurs on the mobile rendering of Forms on Android devices. This is likely due to how certain mobile browsers interact with Microsoft's numeric input fields.
Can I recover the missing digits from a submitted Microsoft Form?
Unfortunately, once the data is submitted and truncated by the system, the missing digits cannot be recovered from the backend. You will need to contact the respondent directly to verify their intended answer.
Is there a workaround to prevent digits from being dropped in Forms?
Yes. A highly effective workaround is to change the question type from a 'Number' field to a 'Text' field. You can then apply a 'Restriction' in the question settings that only allows numeric characters to be submitted.
