Prospects Influential Inc. - Whoever you need to reach, we can help!
direct marketing list brokers
Call
direct marketing lists mailing list brokerage direct marketing list brokers
business mailing lists, business telemarketing lists consumer mailing lists, consumer telemarketing lists
Funny Phone Numbers

Question: Why do the phone numbers in my list look strange? They look something like this:

9.024E+09
9.034E+09
9.021E+09

Answer:
When you open your lists data in Microsoft Excel or other similar programs, the spreadsheet software quickly interprets your data and displays each part of it as either text or numerals. When phone numbers are displayed as pure numerals, Excel considers them numbers that you may wish to perform mathematical calculations with -- even though you don't.

In addition, when you first open your data, by default all the MS Excel columns are the same width. The phone numbers are wider than the columns are, so the spreadsheet can't display them properly. It therefore shows you the numbers using scientific notation, in order to shorten the display -- much the same way a pocket calculator displays numbers that are just too long.

Solution:

In order to properly see the data, you need to widen the columns so that the full phone or fax numbers can be displayed. In MS Excel:

  1. Select the colunms to widen, by clicking the letters at the top of each column.
    Hold down Ctrl or Shift to select multiple columns, or use Ctrl+A to Select All.
  2. Click Format/Column/Auto Fit Selection

Now the columns show you the complete data.



For other Technical Support questions, please contact:
Data Services by Email

Technical Support fee: US$75/hour.
top
Home • About UsAbout Our Clientele • About Direct Marketing ListsHow to Buy and Use ListsFive Steps to Success Business Lists Consumer Lists Mailing Lists Phone Lists List Research Request  • Express RequestTechnical Support  • Privacy PolicyTerms & ConditionsContact Info Site Map
News
Standard Industrial [SIC] Codes
Contact
Customer
Data Pickup
Customer Service call © 1999 - Prospects Influential, Inc. • NN