Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a formula read a result rather than a formula | Excel Discussion (Misc queries) | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
How do I get the formula to show the result on the worksheet? | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions |