| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Function display
Hello,
I have a function in a cell that doesn't calculate the value. Instead, I see the function definition. How do I change this to display the calculated value? -mr |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Function display
Just the one cell?
Was pre-foramtted as text. Change to General then F2 and ENTER Gord Dibben MS Excel MVP On Thu, 7 Jun 2007 10:42:01 -0700, mrivera wrote: Hello, I have a function in a cell that doesn't calculate the value. Instead, I see the function definition. How do I change this to display the calculated value? -mr |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Function display
You're right, it was formatted as text. However, after changing to General
and pressing F2 it didn't change. "Gord Dibben" wrote: Just the one cell? Was pre-foramtted as text. Change to General then F2 and ENTER Gord Dibben MS Excel MVP On Thu, 7 Jun 2007 10:42:01 -0700, mrivera wrote: Hello, I have a function in a cell that doesn't calculate the value. Instead, I see the function definition. How do I change this to display the calculated value? -mr |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Function display
Did you select the troublesome cell, format it as general, then hit F2, then
Enter--in that order? I'd try it once more. mrivera wrote: You're right, it was formatted as text. However, after changing to General and pressing F2 it didn't change. "Gord Dibben" wrote: Just the one cell? Was pre-foramtted as text. Change to General then F2 and ENTER Gord Dibben MS Excel MVP On Thu, 7 Jun 2007 10:42:01 -0700, mrivera wrote: Hello, I have a function in a cell that doesn't calculate the value. Instead, I see the function definition. How do I change this to display the calculated value? -mr -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Function display
Did you press ENTER after F2?
Gord On Thu, 7 Jun 2007 16:53:00 -0700, mrivera wrote: You're right, it was formatted as text. However, after changing to General and pressing F2 it didn't change. "Gord Dibben" wrote: Just the one cell? Was pre-foramtted as text. Change to General then F2 and ENTER Gord Dibben MS Excel MVP On Thu, 7 Jun 2007 10:42:01 -0700, mrivera wrote: Hello, I have a function in a cell that doesn't calculate the value. Instead, I see the function definition. How do I change this to display the calculated value? -mr |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to not display until data entered | Excel Discussion (Misc queries) | |||
| Can't toggle function results display. | Excel Discussion (Misc queries) | |||
| Function to display day in text format | Excel Worksheet Functions | |||
| If function display | Excel Worksheet Functions | |||
| if function display | Excel Worksheet Functions | |||
Linear Mode
