green mark in the top left corner of cells

G

Guest

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
 
P

Peo Sjoblom

Pre Excel 2007 do tools>options>error checking and deselect enable
background error checking
 
G

Gord Dibben

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 Tools>Options>Error Checking for options.


Gord Dibben MS Excel MVP
 
G

Guest

THANK YOU

Gord Dibben said:
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 Tools>Options>Error Checking for options.


Gord Dibben MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GREEN MARK IN THE TOP LEFT CORNER OF THE CELL 1
What are the green arrows in the top left corner of each cell? 5
Green corner in cell?????? 2
What is small green triangle in upper left corner of cell? 6
Non matching text data of the same values 3
Block Arrows in Top Left Corner of Cells 1
What does the green tag in the top left of a cell mean? 1
Formula and Empty Cells 4

Top