Im using Excel 2002 and have a list of phone numbers as 12345 678 900 and
want to change them to 1234 5678900.

When I custom format as 0000 0000000, some of the cells change to that
format but others remain the same. Could there be some other formatting in
the cells that is over-riding the custom number format, and if so, how do I
find it?