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