Knowledge Base

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

Article ID: 131929

Article Last Modified on 8/15/2005

APPLIES TO

This article was previously published under Q131929

SYMPTOMS

If you select a column of unformatted ZIP codes and you attempt to create a Data Map object from this information, you 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 and later, no error message is displayed, but no data is added to the chart.

CAUSE

When you create a Data Map object that is 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, follow these steps:
  1. On the Format menu, click Cells.
  2. Click the Number tab.
  3. In the Category list, click Special.
  4. 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.

Additional query words: XL2000 XL97 8.00 97

Keywords: kbualink97 KB131929


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.