Microsoft KB Archive/131929

= 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


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition

-



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.