View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Non matching text data of the same values

A text cell value = 12345678 with a green triangle in the left upper corner
of the cell will not match a text cell value = 12345678 with no green
triangle when doing a VLOOKUP.
When is the green triangle inserted and how can it be managed.