I want result of a function in the cell and not the function itsel

[Guest]

When I write a function in an Excel sheet in some columns i see the result
and in others I see the function itself.

Any suggestion in how to get the results of the function in the cell?

 

[Guest]

Rana

It's likely that the cells wher you see the function (formula?) are
formatted as text.

Select those cells and format as general then hit F2 and enter.

Mike

 

[Guest]

You can highlight the column or row, then copy, then paste special back on
the same column or row. When you PASTE SPECIAL, choose values. This gives
you the results, but you do lose the formula.

 

[Gord Dibben]

Re-format the cells to General then F2>ENTER on the cells with the function
showing.

If you have many of these, after selecting all cells and re-formatting........

Edit>Replace

What: =

With: =

Replace all.


Gord Dibben MS Excel MVP

 

[Guest]

Mike H, klafert and Gord Dibben; thank you for your answers, this is what
I've been looking for.