| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What are the green triangles, in the upper left corner of a cell. | Excel Discussion (Misc queries) | |||
| Remove green mark upper left several cells Excel? | Excel Worksheet Functions | |||
| How to get rid of green triangles from top-left corner of cells? | Excel Discussion (Misc queries) | |||
| Block Arrows in Top Left Corner of Cells | Excel Discussion (Misc queries) | |||
| What does a small green triangle in the upper left hand corner of. | Excel Discussion (Misc queries) | |||
Linear Mode
