I have imported my contacts from outlook into excel and having trouble
with the phone numbers. for some reason sorting does not go as it should
and a vlookup function does not retrieve anything but #N/A#. Looks like
some of the numbers are still in text somehow, eventhough I selected all
of the cells and put it to number, general.... nothing seems to help.


Anybody know how to solve this problem?


--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=104270