I have an end user who is importing data from an excel spread sheet. For some reason the phone numbers are not displayed properly. It looks like they are being added or multiplied or in some cases commas are being inserted. Can you please help.
This is a discussion on Importing Data within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have an end user who is importing data from an excel spread sheet. For some reason the phone numbers ...
I have an end user who is importing data from an excel spread sheet. For some reason the phone numbers are not displayed properly. It looks like they are being added or multiplied or in some cases commas are being inserted. Can you please help.
If your phone number is not formatted (ie 000-000-0000 or (111) 111-1111) Mappoint tries to use it as a number. If you are using the Data Wizard and try to add data using the phone number field (unformatted phone numbers) the wizard, by default, seems to sum numbers. Try formatting the cells containing the phone numbers to look like xxx-xxx-xxxx or something of the sort. This seems to fix the way the phone numbers are displayed.
There are currently 1 users browsing this thread. (0 members and 1 guests)