Formula Errors

How to Fix Excel Formula Changing to the Character ü

Natalie TaylorNatalie Taylor Oct 23, 2026 869 views

Question details

Users need to resolve an issue where Excel formulas display the character 'ü' rather than the correct numerical output.

How to Fix Excel Formula Changing to the Character ü
Product
Microsoft 365 Excel
Device & OS
Windows
Scenario
Calculating data using formulas and expecting standard numeric results.
Observed behavior
Excel randomly displays the character 'ü' instead of the calculated number, even when the affected cells are formatted as General.
Before you start

Ensure you have saved your current workbook and take note of the specific cells displaying the 'ü' character before proceeding with troubleshooting.

Solution 1Recommended

Open Excel in Safe Mode to Check for Add-in Conflicts

Running Excel in Safe Mode bypasses third-party add-ins, helping you determine if an extension is causing the formula display issue.

Sometimes, active COM or Excel add-ins interfere with how data and formulas are rendered in the worksheet. Safe mode temporarily disables these to isolate the problem.

1
Open the Run Dialog

Press the Windows key + R on your keyboard to open the Run dialog box.

2
Launch Excel in Safe Mode

Type 'excel /safe' into the text box and press Enter or click OK.

3
Test the Workbook

Open the affected workbook while in Safe Mode and check if the formulas still display the 'ü' character.

4
Disable Problematic Add-ins

If the issue is resolved in Safe Mode, navigate to File > Options > Add-ins. Manage your add-ins by disabling them one by one to identify the culprit.

Open Excel in Safe Mode to Check for Add-in Conflicts
Add-in Identification: Disable add-ins one at a time and restart Excel normally after each step to pinpoint exactly which add-in is causing the conflict.
Free Microsoft Office alternative

Switch to WPS Office to Avoid Formula Display Bugs

If Microsoft Excel continues to display incorrect characters or experience add-in conflicts, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for all your spreadsheet needs without the random rendering glitches.

  1. 1. Download and Install: Visit the official WPS website to download and install WPS Office for free.
  2. 2. Open WPS Spreadsheet: Launch the WPS Spreadsheet application from the newly installed suite.
  3. 3. Import Your Excel File: Click 'Open' to load your existing .xlsx workbooks directly without losing any formatting or formulas.
Highly compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Free and lightweight, avoiding heavy system conflicts and lag.Familiar user interface for seamless and immediate migration.Stable formula calculation engine for accurate numeric results.
microsoft office alternative - wps office

Frequently Asked Questions

Why is my Excel formula showing text instead of a number?

This typically happens if the cell is formatted as Text instead of General or Number. Select the cell, change the format to General in the Home tab, then double-click the cell and press Enter to recalculate.

How do I find my exact Excel version and update channel?

Open Excel, click on 'File' in the top-left corner, and select 'Account' (or 'Help' in older versions). Your version number, build, and update channel will be listed under the 'Product Information' section.

Does the 'ü' character indicate a specific Excel error code?

No, the 'ü' character is not a standard Excel error code like #VALUE! or #REF!. It is generally a symptom of a font rendering issue, an add-in conflict, or a corrupted workbook cache.

Can a corrupted font cause Excel to display strange characters?

Yes. If the default font used in your Excel workbook (such as Calibri or Arial) is corrupted or experiencing a system glitch, it may render standard numbers as random symbols like 'ü'. Changing the cell font can help diagnose this.