Hi and thanks
Have some columns that have a triangle in the upper left top corner
of the cells. I understand this is caused by several reason. One
collumn the cells are formated at text and has a number in it, the
others has formulas in them that work just fine.
What can I do to get rid of these triangles?

Thanks
Bob

You can control them by clicking Tools/Options on Excel's menu bar,
selecting the Error Checking tab on the dialog box that appears, and
checking or unchecking the various boxes under the Rules section.

Rick


wrote in message
...
Hi and thanks
Have some columns that have a triangle in the upper left top corner
of the cells. I understand this is caused by several reason. One
collumn the cells are formated at text and has a number in it, the
others has formulas in them that work just fine.
What can I do to get rid of these triangles?

Thanks
Bob

Bob,

Tools / Options.... / Error Checking tab, uncheck "Number stored as Text"

HTH,
Bernie
MS Excel MVP


wrote in message ...
Hi and thanks
Have some columns that have a triangle in the upper left top corner
of the cells. I understand this is caused by several reason. One
collumn the cells are formated at text and has a number in it, the
others has formulas in them that work just fine.
What can I do to get rid of these triangles?

Thanks
Bob

Thanks all
Got it to work..
Bob

On Fri, 11 Apr 2008 12:48:31 -0400, wrote:

Hi and thanks
Have some columns that have a triangle in the upper left top corner
of the cells. I understand this is caused by several reason. One
collumn the cells are formated at text and has a number in it, the
others has formulas in them that work just fine.
What can I do to get rid of these triangles?

Thanks
Bob