Why Excel Displays TRUE or FALSE Instead of a Number | WPS Office
Question details
The user needs to understand why a cell in Excel or WPS Spreadsheets shows TRUE or FALSE after entering a number, and how to restore the expected numeric display.
- Product
- WPS Office Spreadsheets (Excel-compatible)
- Device & OS
- not provided
- Scenario
- The user enters a number into a spreadsheet cell and expects it to remain a numeric value.
- Observed behavior
- The cell displays TRUE or FALSE instead of the entered number.
Select the affected cell and look at the formula bar to see whether the cell contains a formula or a static value. Also note any conditional formatting or data validation rules applied to the cell before changing settings.
Check and Edit the Cell Formula and Nearby Formulas
Use this first when the formula bar shows a logical formula or when nearby cells contain formulas that evaluate the target cell as TRUE or FALSE.
Click the cell that displays TRUE or FALSE, then look at the formula bar to see whether it contains a formula instead of the number you typed.
If the cell contains a logical formula such as =1=1 or =A1>10, delete it or replace it with the intended numeric value.
Select adjacent cells and review their formulas for references to the affected cell that return Boolean results, then edit or remove those references.
Press Enter, type the number again into the cell, and confirm that it now appears as a number.
Clear Conditional Formatting Rules That Force TRUE or FALSE Display
Use this when the cell value looks correct in the formula bar but conditional formatting changes how it is displayed.
Review Data Validation and Number Format Settings
Use this when formulas and conditional formatting do not explain the TRUE or FALSE result.
Fix TRUE/FALSE Display in WPS Spreadsheets
Use WPS Spreadsheets to inspect formulas, clear conditional formatting rules, and reset number formatting so cells display the numeric values you enter instead of Boolean results.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office, open the spreadsheet file, and select the cell showing TRUE or FALSE.
- 2. Clear conditional formatting rules: Go to Home > Conditional Formatting > Clear Rules, then choose to clear rules from the selected cells or the entire sheet.
- 3. Check the formula bar: Look at the formula bar and delete or correct any logical formula in the selected cell or nearby formula references.
- 4. Review data validation: Go to Data > Data Validation and set Allow to Any value if a Boolean or custom validation rule is affecting the cell.
- 5. Reset the number format: Go to Home > Number Format, choose General or Number, then re-enter the number and verify the display.
Frequently Asked Questions
Why does Excel show TRUE or FALSE when I enter a number?
It usually means a formula, conditional formatting rule, or data validation setting is evaluating the entry as a Boolean value. Select the cell, check the formula bar, then review Home > Conditional Formatting and Data > Data Validation.
How do I clear conditional formatting rules in WPS Spreadsheets?
Select the affected cell or range, go to Home > Conditional Formatting > Clear Rules, then choose Clear Rules from Selected Cells or Clear Rules from Entire Sheet.
Can a data validation rule change a number to TRUE or FALSE?
Yes. A custom validation formula can display or enforce a Boolean result. Open Data > Data Validation and set Allow to Any value or correct the custom formula.
What number format should I use if my cell shows TRUE or FALSE?
Use General or Number. Select the cell, go to Home > Number Format, choose General or Number, then re-enter the number.
Will WPS Spreadsheets open Excel files that contain logical formulas?
Yes. WPS Spreadsheets supports Excel formulas and logical functions, so you can open the workbook and edit problematic formulas in a Microsoft Excel-compatible environment.
