How to Fix Excel Formula Changing to the Character ü
Question details
Users need to resolve an issue where Excel formulas display the character 'ü' rather than the correct numerical output.

- 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.
Ensure you have saved your current workbook and take note of the specific cells displaying the 'ü' character before proceeding with troubleshooting.
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.
Press the Windows key + R on your keyboard to open the Run dialog box.
Type 'excel /safe' into the text box and press Enter or click OK.
Open the affected workbook while in Safe Mode and check if the formulas still display the 'ü' character.
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.

Perform a Windows Clean Boot
A clean boot starts Windows with a minimal set of drivers and startup programs, identifying if background software is interfering with Microsoft 365.
Update Microsoft Office to the Latest Version
Updating Office ensures you have the latest bug fixes and patches that might resolve random display issues and software glitches.
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. Download and Install: Visit the official WPS website to download and install WPS Office for free.
- 2. Open WPS Spreadsheet: Launch the WPS Spreadsheet application from the newly installed suite.
- 3. Import Your Excel File: Click 'Open' to load your existing .xlsx workbooks directly without losing any formatting or formulas.

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.




