View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jaleel Jaleel is offline
external usenet poster
 
Posts: 187
Default How do I eliminate the green triangle throughout my spreadsheet?

Hi Patrick,

Go to Tools - Options - Error Checking - Settings. If "Enable background
error checking" is checked, uncheck it.

Regards,

Jaleel

"Patrick Traynor" wrote:

When I get my data into an Excel format from another program, a green
triangle in the upper left corner of most cells appears. The green triangles
seem to prohibit me from using the numbers in some of the calcuations I do.
I know there is a simply process of eliminating the green triangles without
having to do this column by column using the "Text to Columns" feature and I
would like to know this simple process.