small triangle
 

Hi

I find there is a small triangle at the upper-left corner in the
sheet.
Sometimes the number is not a number. I mean it cannot be summed by a
formula like SUM(...). Therefore, I need to hit the small triangle.
then select and convert text to number .
It's quite annoying.
Sometimes it shows update the formula.
Then if I choose it.
The formula like SUM(F5:F10) will change to SUM(F5:F15), and results
in wrong answer.

How can I avoid it?
Or what's the benefit of this?
Oh, I use Excel 2003.

thank you in advance.

Mike

small triangle
 

Tools|Options|Error checking.

And it shows up to help you with things that are common errors. And it sounds
like you're using it the way it was intended--to change text numbers to number
numbers for example.

Mike wrote:

Hi

I find there is a small triangle at the upper-left corner in the
sheet.
Sometimes the number is not a number. I mean it cannot be summed by a
formula like SUM(...). Therefore, I need to hit the small triangle.
then select and convert text to number .
It's quite annoying.
Sometimes it shows update the formula.
Then if I choose it.
The formula like SUM(F5:F10) will change to SUM(F5:F15), and results
in wrong answer.

How can I avoid it?
Or what's the benefit of this?
Oh, I use Excel 2003.

thank you in advance.

Mike

--

Dave Peterson