 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008SUM
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 >Can anyone please tell me why on earth sometimes these stupid green corners >appear. [quoted text clipped - 6 lines] >Ta >J 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. > Can anyone please tell me why on earth sometimes these stupid green corners > appear. [quoted text clipped - 6 lines] > Ta > J 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 > 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? [quoted text clipped - 15 lines] >> Ta >> J |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.