Formatting Issues

Fix Excel Online Percentage Entries Displaying Numbers Backwards

Maira MehtabMaira Mehtab Oct 21, 2026 868 views

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.

Fix Excel Online Percentage Entries Displaying Numbers Backwards
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.
Before you start

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.

Solution 1Recommended

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.

1
Select a default cell

Click on an empty cell that is currently set to the default 'General' format.

2
Enter the value

Type your desired numerical value using your keyboard without adding the percent sign manually, then press 'Enter'.

3
Apply percentage style

Select the cell you just populated, navigate to the 'Home' tab on the ribbon, and click the '%' (Percentage Style) button in the Number group.

Enter Data as General Text and Apply Percentage Formatting
Temporary Workaround: This method avoids the carriage return and backwards text bug while retaining accurate data for formulas.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
  2. 2. Open WPS Spreadsheet: Launch WPS Spreadsheet from the main dashboard.
  3. 3. Edit your file seamlessly: Open your existing .xlsx workbook and enter percentage values without any backwards text or formatting glitches.
Fully compatible with Microsoft Excel (.xlsx, .xls) files and percentage formatting.Stable desktop application that avoids browser-based input bugs entirely.Familiar user interface with zero learning curve for Excel users.Free and lightweight, consuming minimal system resources.
microsoft office alternative - wps office

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.