HOW TO: Use Microsoft Map to Display Postal Code Centers in Excel 2000

Select the range of the ZIP code data, and then click Cells on the Format menu. In the Format Cells dialog box, click Special under Category, and then click Zip Code under Type (click Zip Code+4 if you are using the nine-digit ZIP code format). Canada Mic

support.microsoft.com