Formula Errors

Fix Excel Showing a Worksheet Reference Instead of a Cell Value

Tauseeq MagsiTauseeq Magsi Nov 14, 2026 868 views

Question details

The user needs an Excel worksheet reference to display the referenced cell value instead of the formula.

Fix Excel Showing a Worksheet Reference Instead of a Cell Value
Product
Microsoft Excel
Device & OS
not provided
Scenario
A cell refers to another worksheet with a formula such as =Title!B31.
Observed behavior
Excel displays the worksheet reference as text instead of the referenced value.
Before you start

Select the affected cell and check whether its number format is Text on the Home tab. Also note whether other formula cells display formulas instead of results.

Solution 1Recommended

Change the cell format and re-enter the reference

Use this when the affected cell was formatted as Text before the formula was entered.

1
Select the affected cell

Click the cell displaying a reference such as =Title!B31.

2
Apply the General format

On the Home tab, open the Number Format list and select General.

3
Re-enter the formula

Click the formula bar, confirm the reference begins with =, and press Enter. Changing the format alone does not convert the existing text into a formula.

Change the cell format and re-enter the reference
Free Microsoft Office alternative

Work with worksheet references in WPS Spreadsheet

WPS Office is a free, lightweight alternative for working with spreadsheets. Its familiar interface and Excel format compatibility make it easy to move existing workbooks into WPS Spreadsheet.

Create and edit references between worksheetsOpen and save Microsoft Excel XLS and XLSX filesNavigate a familiar spreadsheet interfaceUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show =Title!B31 instead of the value?

The cell may have been formatted as Text when the formula was entered, or Show Formulas may be enabled. Set the cell to General on the Home tab, re-enter the formula, and check Formulas > Show Formulas.

Why did changing the cell format to General not fix the formula?

Changing the format does not automatically convert an existing text entry into a formula. After selecting General, click the formula bar and press Enter to re-enter the reference.

How do I reference a worksheet whose name has spaces?

Enclose the worksheet name in single quotation marks, followed by an exclamation mark and the cell reference. For example, enter ='Project Title'!B31.

How can I create a reference by clicking another worksheet?

In the destination cell, type =, click the source worksheet tab, select the source cell, and press Enter. Excel inserts the worksheet reference for you.