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.
|