| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Unfortunately I think your file is corrupted.
"Anthony" wrote: the same as before, ie the result is shown but the formula goes ..aaarrrrgggghhhh !!!!! "bj" wrote: yes that is what I was asking if you enter using the check mark next to the formula line, what happens? I hope someone else has a solution, cause if it is not a macro or something causing the enter key to act different, you may need to regenerate the file. "Anthony" wrote: Sorry keyboard only has an 'ENTER' key..if that is what you were asking "bj" wrote: It sounds as though the "return" key is also functioning as the F9 key normally does on selected items. If your keyboard has an enter key as well as a return key, does it do the same thing? "Anthony" wrote: BJ, I have lots of cells populated with Formula but they are working fine, its just when I place a new formula in a new cell. ....and yes I have macros (I'm affraid I have lots !!!) thanks "bj" wrote: Is this happening in any other cell? do you have any macros? "Anthony" wrote: Hi, In cell N2 I have a simple formula to count the total number of rows in a given range that are populated, here it is COUNTA(B8:B100) problem is I enter the formula either directly into the cell or into the formula bar , as soon I hit the enter key the answer is given, but the formula disappears any ideas thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula that referance a Cell | Excel Discussion (Misc queries) | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| looking for a formula | Excel Worksheet Functions | |||
Hybrid Mode
