MapInfo Pro

Welcome to the MapInfo Pro community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

Where are my leading 0's? - How to resolve issues due to missing leading zeros

  • 1.  Where are my leading 0's? - How to resolve issues due to missing leading zeros

    Employee
    Posted 08-01-2017 13:29

    Frequently character data such as ZIPCODES start with a leading zero - ZIPCODES in NJ and CT for example.....

    ?When this character data is opened in MapInfo Pro. frequently the data is incorrectly interpreted by MapInfo Pro as being numeric in type, and therefore removes any leading zeros, as numeric data does not start with a zero.

    ?See these articles for assistance in resolving this issue, using MapInfo Pro or Excel:

    The following link is no longer available. To access this information, copy the title found in the url into the search tool on the top nav bar, or try searching for key words in the post. https://li360.pitneybowes.com/s/article/ka1800000004X11AAE/How-to-add-a-zero-to-the-beginning-of-a-number-in-a-character-column-in-MapInfo-Professional

    The following link is no longer available. To access this information, copy the title found in the url into the search tool on the top nav bar, or try searching for key words in the post. https://li360.pitneybowes.com/s/article/ka2800000004UVpAAM/How-to-add-leading-zeros-0-to-zipcodes-in-Microsoft-Excel?