SUM

  • Thread starter Thread starter ML
  • Start date Start date
M

ML

Can anyone please tell me why on earth sometimes these stupid green corners
appear.
when I do a sum with any of them I get a zero.
If I ignore the green corner things , it won't count, but if I convert to
number it works. So if I go to Format Cells and change to Number, why
doesn't that do it!! and how can I avoid getting those stupid green things.
Surely by default if you type in a number it means you want it as a
number.?
Ta
J
 
If the cell was pre-formatted as Text you can get a number that looks like a
number but is not.

That's why you get the "stupid" green corner which is an error-checking
triangle.

Simply re-formatting number does not always work.

Format all to General then copy an empty cell.

Select the "numbers" and Edit>Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP
 
Well, you could also say "surely by default if you format a cell as
Text, then if you type in a number is means you want it as Text", right?

Once a value is entered as Text, XL assumes it should remain as text,
which is why you have to reenter the value once you've reformatted the
cell with a number format.
 
ahhhhhhhhhhhh., got you.
Yes come to think of it now, it's when i've tried to count stuff I've
pasted from cells from another file which may have been formated as text.or
not have been formatted at all.
Thank you
J
 
Back
Top