"Martin ©¿©¬" wrote:
On Mon, 11 Nov 2013 20:34:22 +0100, Claus Busch wrote:
Am Mon, 11 Nov 2013 19:26:07 +0000 schrieb Martin:

However, there is still a little green triangle in the upper left-hand
corner of the cell, saying thet there is an error in the formula?

open the error smarttag and click "ignore"
[....]
So everytime I input a number I have to do that?
Is ther a better way?

Yes, disable "background error checking". How you do that depends on the
version of Excel, which you did not mention.

For Excel 2003, click on Tools, Options, Error Checking, and deselect
"Enable background error checking".

For Excel 2010, click on File, Options, Formula, and deselect "Enable
background error checking".

What you need to realize is: usually these are not real errors, despite
Excel's effort to mislead you.

Instead, they are warnings that Excel has determined something in those
cells is different from some adjacent cells. Different; not necessarily an
error.

Excel just wants to draw your attention to the difference, on the off-chance
it is indeed a mistake.

But 99 times out of 100, there is no mistake at all. You have simply chosen
to do something different. Klunk!