Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 27th 07, 04:39 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 9
Default 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   Report Post  
Old November 27th 07, 05:10 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default Green Triangle in Upper Left Corner of Cell

ToolsOptionsError Checking.

Disable error-checking 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   Report Post  
Old November 27th 07, 05:39 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 9
Default Green Triangle in Upper Left Corner of Cell

On Nov 26, 8:10 pm, Gord Dibben <gorddibbATshawDOTca wrote:
ToolsOptionsError Checking.

Disable error-checking 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
green triangle top left corner of cell in Excel Bobbi Excel Discussion (Misc queries) 1 November 12th 07 07:41 PM
Blue triangle in top left corner of cell? Bill (St. Jude) New Users to Excel 4 October 22nd 07 09:01 PM
What are the green triangles, in the upper left corner of a cell. Humber Excel Discussion (Misc queries) 3 October 4th 06 02:35 PM
what is the little black triangle in the upper left corner of a cell FireBrick New Users to Excel 4 October 1st 06 11:13 PM
What does a small green triangle in the upper left hand corner of. Fleas32 Excel Discussion (Misc queries) 3 December 29th 04 08:07 PM


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017