How to Fix Numbers or Figure Labels Displaying Right to Left in Office
Question details
User needs to correct numbers or figure labels that are displaying right-to-left instead of the standard left-to-right format.
- Product
- Office
- Device & OS
- not provided
- Scenario
- Working with documents or spreadsheets containing mixed language settings, bidirectional text, or imported data.
- Observed behavior
- Numbers, cells, and figure labels appear backwards or right-to-left due to incorrect language or text direction formatting.
Check your system's default keyboard language and region settings, as these can sometimes automatically trigger right-to-left text direction when typing or pasting content into Office applications.
Fix Right-to-Left Numbers in Spreadsheets Using Format Cells
Apply standard number and alignment formatting to reset the text direction in spreadsheet cells.
When dealing with imported data or mixed language settings, spreadsheet cells may inadvertently inherit right-to-left properties. You can clear this by explicitly defining the cell's alignment and number format.
Highlight the spreadsheet cells containing the numbers that are displaying right-to-left.
Right-click the highlighted selection and choose 'Format Cells' from the context menu.
Navigate to the 'Number' tab and select your desired standard number format from the category list.
Switch to the 'Alignment' tab, ensure the 'Text direction' dropdown is set to 'Left-to-Right' or 'Context', and click 'OK'.
Correct Figure Labels and Paragraph Direction in Word Documents
Adjust paragraph settings and disable bidirectional text to fix figure labels displaying backwards.
Use WPS Office to Fix Text Direction and Formatting Issues
WPS Office provides intuitive text alignment and bidirectional text controls, allowing you to easily fix right-to-left numbers or labels across Writer and Spreadsheets while maintaining full compatibility with Microsoft Office formats.
- 1. Open your file in WPS Office: Launch WPS Office and open the document or spreadsheet containing the formatting issues.
- 2. Adjust spreadsheet cells: In WPS Spreadsheets, select the affected cells, right-click, choose 'Format Cells', and change the Text direction under the Alignment tab.
- 3. Adjust document text: In WPS Writer, select the backwards text and click the 'Left-to-Right Text Direction' icon located in the Home tab.
- 4. Save the changes: Save your file. The corrected text direction and number formatting will be permanently applied.
Frequently Asked Questions
Why did my numbers suddenly change to right-to-left?
This usually happens if you accidentally press a keyboard shortcut for bidirectional text, paste text from a source with right-to-left formatting, or if a right-to-left language pack is active on your system.
How do I remove Arabic or Hebrew formatting from English text?
Select the text, navigate to the Language settings on the bottom status bar, change the language back to English, and ensure the Left-to-Right paragraph direction is selected on the Home tab.
Can I change the default text direction for all new documents?
Yes, you can set the default text direction by modifying your Normal template. Open the Paragraph settings, select Left-to-Right, and click 'Set as Default' for all documents based on the template.
Will fixing the text direction alter my numeric values?
No, changing the text direction or alignment only affects how the numbers are visually displayed on the screen and in print. The actual mathematical values stored in your file remain completely unchanged.
