XL: Zip Codes in Data Map Must Be Formatted with Zip Code Style

Last reviewed: June 3, 1997
Article ID: Q131929

7.00 97 WINDOWS kbole kbtool

The information in this article applies to:

Microsoft Excel for Windows 95, version 7.0
Microsoft Excel 97 for Windows

SYMPTOMS

If you select a column of unformatted zip codes and you attempt to create a Data Map object from this information, you will receive the following error message in Microsoft Excel version 7.0:

   A column of data in your selection must contain geographical data.

In Microsoft Excel 97, no error message displays, but no data populates the chart.

CAUSE

When you create a Data Map object based on zip codes, the zip codes must be formatted with the special Zip Code number format.

WORKAROUND

To format a range of zip codes, use the following steps:

On the Format menu, click Cells.
Click the Number tab.
In the Category list, click Special.
In the Type list, click the Zip Code or the Zip Code + 4 format.

STATUS

This behavior is by design to prevent the possible misinterpretation of numeric data as zip codes.

KBCategory: kbole kbtool
KBSubcategory: xlmap
Additional reference words: 7.00 8.00 97
Keywords : kbualink97 xlmap kbole kbtool
Version : 7.00 97
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 3, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.