first use isnumber(A1) to find cells with text. If the phone numbers are in
column A the put formula in column B and copy down column B. the find one of
the cells that isn't a number. There is a white invisible charact in the
cell. Go to F(x) and copy only 1 of the invisible characters by typing
Cntl-C. Then go to worksheet menu Edit - Replace. Paste the character into
the From box by typing Cnt-F. Then Replace All. At least one character
should of been replaced. If there are still more non-numeric values repeat
the process until all are gone. there are two or 3 different invisible
characters that can cause this problem.
"willemeulen" wrote:
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