View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default I want result of a function in the cell and not the function itsel

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

"Rana" wrote:

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?