Fix Excel Online Percentage Entries Displaying Numbers Backwards
Question details
Users experience a bug in Excel for the web where typing numbers into a percentage-formatted cell causes the text to display in reverse or introduces unwanted line breaks.

- Product
- Excel Online
- Device & OS
- not provided
- Scenario
- Manually entering numerical data into an Excel web cell that has been previously formatted as a percentage.
- Observed behavior
- The typed numbers render backwards or generate unexpected carriage returns, displaying corrupted formatting instead of standard percentage values.
Verify that your web browser (such as Firefox or Chrome) is fully updated, and temporarily disable browser extensions to ensure they are not interfering with web scripts.
Enter Data as General Text and Apply Percentage Formatting
Bypass the web browser input bug by typing the numbers in a standard cell first and applying the percentage format afterward.
Since the input bug only triggers when typing directly into a cell that is already formatted as a percentage, changing the order of your actions avoids the glitch entirely.
Click on an empty cell that is currently set to the default 'General' format.
Type your desired numerical value using your keyboard without adding the percent sign manually, then press 'Enter'.
Select the cell you just populated, navigate to the 'Home' tab on the ribbon, and click the '%' (Percentage Style) button in the Number group.

Use the Desktop Application Instead of the Web App
Switch from the browser-based Excel Online to a desktop spreadsheet application where this web-specific bug does not occur.
Switch to WPS Office for Reliable Spreadsheet Formatting
Avoid frustrating web browser formatting bugs with WPS Office. WPS Spreadsheet offers a powerful, lightweight, and completely free desktop experience with seamless compatibility for all your Excel files.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open WPS Spreadsheet: Launch WPS Spreadsheet from the main dashboard.
- 3. Edit your file seamlessly: Open your existing .xlsx workbook and enter percentage values without any backwards text or formatting glitches.

Frequently Asked Questions
Why do numbers type backwards in Excel Online?
This is a known bug in Excel for the web, often triggered when entering data into a cell already formatted as a percentage. It is primarily observed in web browsers like Mozilla Firefox and Google Chrome due to web script handling issues.
Does this percentage bug happen in the desktop version of Excel?
No, this specific formatting issue is isolated to the web version of Excel. Using a desktop spreadsheet application like WPS Office resolves the problem completely.
Can a corrupted workbook cause this formatting issue?
While corrupted workbooks can cause odd behavior, users have reported this bug occurring in completely new, blank workbooks in Excel Online, indicating it is an application bug rather than file corruption.
Will this bug affect the actual data value used in formulas?
Yes, if the bug introduces hidden carriage returns or backwards digits into the cell, it can corrupt the data type, causing formulas referencing those cells to return errors like #VALUE! or calculate incorrectly.




