Precede it with another ~.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"P Koh" <P wrote in message
...
Why is it that when I use ~ in any of the cell in Excel, I can't do
Vlookup
or any seach function.