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
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