Problem vlookup ->solution macro

[Michel8]

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

 

[Frank Kabel]

Hi
try the following:
- select an empty cell and copy this cell
- select your numbers
- goto 'Edit - Paste Special' and choose the action 'Add'

another option: try the following macro (after selecting your data)

sub foo()
with selection
..value=.value
end with
end sub