small triangle

M

Mike

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top