Phone numbers are generally textual.

Why would you want them to be numbers?

You want to calculate with them?


Gord Dibben MS Excel MVP

On Sun, 7 Jun 2009 13:52:58 +0100, 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?