Green Triangle in Upper Left Corner of Cell

  • Thread starter Clueless in Seattle
  • Start date

C

Clueless in Seattle

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

Advertisements

G

Gord Dibben

Tools>Options>Error Checking.

Disable error-checking or parts you don't want.

I have it disabled totally.


Gord Dibben MS Excel MVP
 
Ad

Advertisements

C

Clueless in Seattle

Tools>Options>Error Checking.

Disable error-checking or parts you don't want.

I have it disabled totally.

Gord Dibben MS Excel MVP

That was easy!

Thanks!
 

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