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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Michel8" schrieb im Newsbeitrag
...

Hi,

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

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

KR,

Michel


--
Michel8
---------------------------------------------------------------------
---
Michel8's Profile:
http://www.excelforum.com/member.php...o&userid=16804
View this thread:
http://www.excelforum.com/showthread...hreadid=320043