MacXL: Cell Linked to Text-Formatted Cell Shows Formula Not Value (191156)
The information in this article applies to:
- Microsoft Excel 2001 for Mac
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q191156 SYMPTOMS
In Microsoft Excel, if you enter a formula that links one cell to a cell
that is formatted with the Text number format, the cell that contains the
link is also formatted as text. If you then edit the formula in the linked
cell, the formula is displayed in the cell rather than the value that is
returned by the formula.
CAUSE
When you link cells in Microsoft Excel, the format of the original cell is
applied to the linked cell. Therefore, if you enter a formula that links one
cell to a cell formatted as text, the cell with the formula is also
formatted as text.
WORKAROUND
To display the calculated value rather than the formula, you must change the format of the cell containing the formula and re-enter the formula.
To do this, follow these steps:
- Select the cell with the formula, and then click Cells on the Format menu.
- Click the Number tab. In the Category list, click the format that you want the cell to display, and then click OK.
The cell still displays the formula.
- Select the cell with the formula, press F2, and then press ENTER.
The cell displays the value.
- In the same cell, click Cells on the Format menu.
The cell format category will be Text.
- Specify the category and format options for the cell and then click
OK.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbprb KB191156 |
|---|
|