The information in this article applies to:
SYMPTOMSIf 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: In Microsoft Excel 97, no error message displays, but no data populates the chart. CAUSEWhen 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:
STATUSThis behavior is by design to prevent the possible misinterpretation of numeric data as zip codes. Additional query words: 8.00 97
Keywords : kbualink97 xlmap |
Last Reviewed: May 2, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |