ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why does the formula show instead of the result? (https://www.excelbanter.com/excel-discussion-misc-queries/97665-why-does-formula-show-instead-result.html)

carpfish

Why does the formula show instead of the result?
 
Instead of the result of a formula showing up in the cell, the formula itself
is displayed.

Chip Pearson

Why does the formula show instead of the result?
 
Does this happen to all formulas or just one? The cell is likely
formatted as Text. Change the format to General and then select
the cell. Press F2 then Enter.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"carpfish" wrote in message
...
Instead of the result of a formula showing up in the cell, the
formula itself
is displayed.




Die_Another_Day

Why does the formula show instead of the result?
 
sounds like you either forgot the "=" in front of your formula or it is
formatted as text

HTH

Die_Another_Day


carpfish wrote:
Instead of the result of a formula showing up in the cell, the formula itself
is displayed.



Marcelo

Why does the formula show instead of the result?
 
HI

tools | options | view | Formula

hth
regards from Brazil
Marcelo

"carpfish" escreveu:

Instead of the result of a formula showing up in the cell, the formula itself
is displayed.



All times are GMT +1. The time now is 12:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com