Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.newusers




Green Triangle in Upper Left Corner of Cell
I'm keeping track of my eBay purchases with an Excel 2003 work sheet.
I have one column for item numbers (each item auctioned on eBay is assigned a unique number). It seemed logical to format the cells in this column as text, since I cannot imagine any reason why I would ever want to perform mathematical operations with these numbers. I did experiment with formatting the cells in the column as numbers, but then the numbers appeared in a strange way. For example, the number which appears in text as 300153751051, appears in number format as 3.00154E+11. So, even if I wanted to format the cells as numbers, I wouldn't know how to read the numbers. But, with the cells formatted as text, when I enter item numbers into these cells, little green triangles appears in the upper left corners of the cells. These little triangles are annoying little eyesores, sort of like getting a speck of grit in your eye. Is there a way I can format the column so that these triangles will disappear. And if so, is there any reason why I shouldn't get rid of them? Will in Seattle a.k.a. "Clueless" 
#2
Posted to microsoft.public.excel.newusers




Green Triangle in Upper Left Corner of Cell
ToolsOptionsError Checking.
Disable errorchecking or parts you don't want. I have it disabled totally. Gord Dibben MS Excel MVP On Mon, 26 Nov 2007 19:39:55 0800 (PST), Clueless in Seattle wrote: I'm keeping track of my eBay purchases with an Excel 2003 work sheet. I have one column for item numbers (each item auctioned on eBay is assigned a unique number). It seemed logical to format the cells in this column as text, since I cannot imagine any reason why I would ever want to perform mathematical operations with these numbers. I did experiment with formatting the cells in the column as numbers, but then the numbers appeared in a strange way. For example, the number which appears in text as 300153751051, appears in number format as 3.00154E+11. So, even if I wanted to format the cells as numbers, I wouldn't know how to read the numbers. But, with the cells formatted as text, when I enter item numbers into these cells, little green triangles appears in the upper left corners of the cells. These little triangles are annoying little eyesores, sort of like getting a speck of grit in your eye. Is there a way I can format the column so that these triangles will disappear. And if so, is there any reason why I shouldn't get rid of them? Will in Seattle a.k.a. "Clueless" 
#3
Posted to microsoft.public.excel.newusers




Green Triangle in Upper Left Corner of Cell
On Nov 26, 8:10 pm, Gord Dibben <gorddibbATshawDOTca wrote:
ToolsOptionsError Checking. Disable errorchecking or parts you don't want. I have it disabled totally. Gord Dibben MS Excel MVP That was easy! Thanks! 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
what is the little black triangle in the upper left corner of a cell  New Users to Excel  
green triangle top left corner of cell in Excel  Excel Discussion (Misc queries)  
Blue triangle in top left corner of cell?  New Users to Excel  
What are the green triangles, in the upper left corner of a cell.  Excel Discussion (Misc queries)  
What does a small green triangle in the upper left hand corner of.  Excel Discussion (Misc queries) 