Hi,

I have exported a file from our information system. With a vlooku
formula I want to add information from another worksheet. But the ke
(a clientnumber) is of such a format, the formula doesn't work. I hav
to select the cell, give an enter and then the formula works. Bu
clicking through 20.000 cells is a little bit too much.

First I was using a macro, but the macro is deleted from m
computer....and I can't write a macro. Is there any other solution???

KR,

Miche

--
Michel
-----------------------------------------------------------------------
Michel8's Profile: http://www.excelforum.com/member.php...fo&userid=1680
View this thread: http://www.excelforum.com/showthread.php?threadid=32004