Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula will not show value
I have 2007. While scrolling down Excel went into recovery mode. Now my
functions will not show the value in the cell. in Formula wizard the resultant value is correct, but stil does not transfer to the cell value. I see the formula only. I tried going to teh Formula toolbar and clicking 'show Formulas' the cell toggles to show more formula or less. HELP! TIA |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula will not show value
FYI the display Option under advanced is set to display the value vs. the
formula and set to auto-calculate. "Candyman" wrote: I have 2007. While scrolling down Excel went into recovery mode. Now my functions will not show the value in the cell. in Formula wizard the resultant value is correct, but stil does not transfer to the cell value. I see the formula only. I tried going to teh Formula toolbar and clicking 'show Formulas' the cell toggles to show more formula or less. HELP! TIA |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula will not show value
Good chance the cells were re-formatted as text.
Format all to General then select a cell and F2 then ENTER. OK now? If many cells you can do an EditReplace after formatting all to General. What: = With: = Replace all Gord Dibben MS Excel MVP On Tue, 16 Dec 2008 10:23:01 -0800, Candyman wrote: I have 2007. While scrolling down Excel went into recovery mode. Now my functions will not show the value in the cell. in Formula wizard the resultant value is correct, but stil does not transfer to the cell value. I see the formula only. I tried going to teh Formula toolbar and clicking 'show Formulas' the cell toggles to show more formula or less. HELP! TIA |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula will not show value
That was it! I had checked the formating and set to general (from text), but
no luck. Replacing the equals sign fixed it. Thanks! "Gord Dibben" wrote: Good chance the cells were re-formatted as text. Format all to General then select a cell and F2 then ENTER. OK now? If many cells you can do an EditReplace after formatting all to General. What: = With: = Replace all Gord Dibben MS Excel MVP On Tue, 16 Dec 2008 10:23:01 -0800, Candyman wrote: I have 2007. While scrolling down Excel went into recovery mode. Now my functions will not show the value in the cell. in Formula wizard the resultant value is correct, but stil does not transfer to the cell value. I see the formula only. I tried going to teh Formula toolbar and clicking 'show Formulas' the cell toggles to show more formula or less. HELP! TIA |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula will not show value
Good to hear
Gord On Tue, 16 Dec 2008 11:34:01 -0800, Candyman wrote: That was it! I had checked the formating and set to general (from text), but no luck. Replacing the equals sign fixed it. Thanks! "Gord Dibben" wrote: Good chance the cells were re-formatted as text. Format all to General then select a cell and F2 then ENTER. OK now? If many cells you can do an EditReplace after formatting all to General. What: = With: = Replace all Gord Dibben MS Excel MVP On Tue, 16 Dec 2008 10:23:01 -0800, Candyman wrote: I have 2007. While scrolling down Excel went into recovery mode. Now my functions will not show the value in the cell. in Formula wizard the resultant value is correct, but stil does not transfer to the cell value. I see the formula only. I tried going to teh Formula toolbar and clicking 'show Formulas' the cell toggles to show more formula or less. HELP! TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show and copy values in formula bar containing a formula | Excel Discussion (Misc queries) | |||
Dont show formula in formula bar | Excel Discussion (Misc queries) | |||
My formula will not show the result, only the formula. | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |