View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default What are the green arrows in the top left corner of each cell?

Most likely number formatted as text, format a cell as number or general,
copy it, select the text numbers and do editpaste special and select add


--
Regards,

Peo Sjoblom



"Don" wrote in message
...
I'm trying to do a vlookup on a list of accounts. The cells that have
green
arrows in the top left corner give me no result. I think it has to do
with
formating but I haven't been able to figure it out.