green mark in the top left corner of cells
 

whne i import data i sometimes get a green mark in the top left corner. This
screws up matching when doing a vlookup. how do i get rid of the green mark?

thx

green mark in the top left corner of cells
 

Pre Excel 2007 do toolsoptionserror checking and deselect enable
background error checking


--
Regards,

Peo Sjoblom



"leo" wrote in message
...
whne i import data i sometimes get a green mark in the top left corner.
This
screws up matching when doing a vlookup. how do i get rid of the green
mark?

thx

green mark in the top left corner of cells
 

It is not the error-checking arrow that is screwing up your VLOOKUP

The error-checking indicates inconsistent data like number stored as text.

See ToolsOptionsError Checking for options.


Gord Dibben MS Excel MVP

On Thu, 21 Jun 2007 14:24:01 -0700, leo wrote:

whne i import data i sometimes get a green mark in the top left corner. This
screws up matching when doing a vlookup. how do i get rid of the green mark?

thx

green mark in the top left corner of cells
 

THANK YOU

"Peo Sjoblom" wrote:

Pre Excel 2007 do toolsoptionserror checking and deselect enable
background error checking


--
Regards,

Peo Sjoblom



"leo" wrote in message
...
whne i import data i sometimes get a green mark in the top left corner.
This
screws up matching when doing a vlookup. how do i get rid of the green
mark?

thx

green mark in the top left corner of cells
 

THANK YOU

"Gord Dibben" wrote:

It is not the error-checking arrow that is screwing up your VLOOKUP

The error-checking indicates inconsistent data like number stored as text.

See ToolsOptionsError Checking for options.


Gord Dibben MS Excel MVP

On Thu, 21 Jun 2007 14:24:01 -0700, leo wrote:

whne i import data i sometimes get a green mark in the top left corner. This
screws up matching when doing a vlookup. how do i get rid of the green mark?

thx