triangle in cell

[robertt3]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Bernie Deitrick]

Bob,

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

HTH,
Bernie
MS Excel MVP

 

[robertt3]

Thanks all
Got it to work..
Bob