Why doesn’t my spreadsheet have phone numbers? What are these weird characters?

There are two reasons why your list may not have numbers. If you are seeing “weird characters” or “weird numbers” where the phone number should be, it is generally your software shortening the phone number and representing it as a mathematical expression. To fix that, you can simply expand the column to provide enough room for the entire number to display and then you should be golden. Another way to check is to click on the “weird number” and then look at the formula bar, it should show the full phone number there instead of the mathematical expression of what it assumes is a large number.

The second reason you may not have phone numbers is that not all of our records have phone numbers. Depending on the selections you made during your search you may have requested all records, whether or not they have phone numbers.

« Back to the Knowledgebase