Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want result of a function in the cell and not the function itsel
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want result of a function in the cell and not the function itsel
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. "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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want result of a function in the cell and not the function itsel
Re-format the cells to General then F2ENTER on the cells with the function
showing. If you have many of these, after selecting all cells and re-formatting........ EditReplace What: = With: = Replace all. Gord Dibben MS Excel MVP On Sun, 1 Jul 2007 00:28:00 -0700, 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want result of a function in the cell and not the function i
Mike H, klafert and Gord Dibben; thank you for your answers, this is what
I've been looking for. "Gord Dibben" wrote: Re-format the cells to General then F2ENTER on the cells with the function showing. If you have many of these, after selecting all cells and re-formatting........ EditReplace What: = With: = Replace all. Gord Dibben MS Excel MVP On Sun, 1 Jul 2007 00:28:00 -0700, 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I write the IF function to reflect the result in one cell? | Excel Worksheet Functions | |||
Link a cell from another worksheet as a result in a function? | Excel Worksheet Functions | |||
Color a result cell in a user defined function | Excel Discussion (Misc queries) | |||
Valid formula result in Function Box but Cell displays #VALUE | Excel Discussion (Misc queries) | |||
Using result from ADDRESS function as a cell reference itself | Excel Worksheet Functions |