How to Fix Excel or Form Fields Not Accepting Decimal Places
Question details
The user is experiencing an issue where Excel cells or form fields refuse to accept or display decimal places, often rounding numbers up or behaving as if only integers are allowed.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Entering numerical data that requires specific decimal precision into spreadsheet cells or form controls.
- Observed behavior
- Fields stop accepting decimal places, round entered numbers to whole integers, or drop required decimal precision despite the user needing fractional values.
Before modifying your settings, verify that your column width is wide enough to display the full number, as spreadsheets sometimes round numbers visually if the column is too narrow.
Configure Number Formatting and Precision Settings
Adjust the cell or control format to explicitly display the required number of decimal places to prevent visual rounding.
Often, the underlying value still contains the decimals, but the cell format is restricting the display to integers. Adjusting the format ensures the exact entered value is shown.
Highlight the spreadsheet cells or select the form controls that are rounding your decimal numbers.
Right-click on the selected area and choose 'Format Cells' from the context menu.
Navigate to the 'Number' tab and click on 'Number' in the category list on the left.
Adjust the 'Decimal places' counter to your required precision (e.g., 3). Alternatively, choose 'Custom' and enter a format code like 0.000.
Click 'OK' to apply the formatting. Your numbers should now display the correct decimal places without rounding.

Modify Data Validation Rules
Check and update data validation settings to ensure the field isn't restricted to accepting whole numbers only.
Manage Number Formatting and Decimal Places in WPS Spreadsheet
WPS Spreadsheet provides intuitive formatting tools to ensure your data is displayed exactly as you need it, avoiding unwanted rounding or missing decimal places. You can easily enforce data validation and format rules with just a few clicks.
- 1. Open your file in WPS Office: Launch WPS Spreadsheet and open the document containing the numerical data.
- 2. Select the target cells: Highlight the cells or columns where you want to enforce decimal places.
- 3. Adjust decimals quickly: On the 'Home' tab, click the 'Increase Decimal' or 'Decrease Decimal' icons to quickly change the precision.
- 4. Set advanced formatting: Press 'Ctrl + 1' to open the Format Cells dialog, select 'Number', and define the exact decimal rules you need.

Frequently Asked Questions
Why does Excel round my decimals to whole numbers automatically?
This usually happens when the column is too narrow to display the decimal places or if the default cell format is set to display zero decimal places. Adjusting the column width or modifying the cell's number format to include decimals will fix this issue.
Can the first value entered dictate the format for the rest of the form controls?
In standard spreadsheet cells, the first value entered doesn't restrict subsequent values unless a specific macro or intelligent table formatting is applied. However, certain dynamically linked form controls might inherit the format based on the initial input if not explicitly configured beforehand.
How do I stop the spreadsheet from dropping the trailing zero in decimals?
By default, the 'General' number format drops trailing zeros (e.g., 4.10 becomes 4.1). To keep trailing zeros visible, change the cell format to 'Number' and specify the exact amount of decimal places you want, or use a custom format code like 0.00.




