Display numbers as postal codes - Microsoft Support
Excel provides two special number formats for postal codes, called Zip Code and Zip Code + 4. If these don't meet your needs, you can create your own custom postal code format.
Prepare your Excel data source for a Word mail merge - Microsoft …
Use mail merge to create and send bulk mail, labels, and envelopes. Mail merge - A free, 10 minute, video training. If you've built a contact list in an Excel spreadsheet, it's important to format any zip codes or postal codes as text to avoid losing data.
ADDRESS function - Microsoft Support
Description. You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. For example, ADDRESS (2,3) returns $C$2. As another example, ADDRESS (77,300) returns $KN$77.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
It's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
Available number formats in Excel - Microsoft Support
Displays a number as a postal code (ZIP Code), phone number, or Social Security number. Custom. Allows you to modify a copy of an existing number format code. Use this format to create a custom number format that is added to the list of number format codes.
Get and prep your data for 3D Maps - Microsoft Support
This could be a Latitude/Longitude pair, City, Country/Region, Zip code/Postal code, State/Province, or Address. The accuracy of 3D Maps depends on the amount and variety of geographic data you provide and the search results from Bing.
Display numbers as postal codes - Microsoft Support
Excel provides two special number formats for postal codes, called Zip Code and Zip Code + 4. If these don't meet your needs, you can create your own custom postal code format. Apply a predefined postal code format to numbers
TEXT function - Microsoft Support
The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.
Get started with 3D Maps - Microsoft Support
When you have Excel data that has geographic properties in table format or in a Data Model—for example, rows and columns that have names of cities, states, counties, zip codes, countries/regions, or longitudes and latitudes—you’re ready to get started. Here’s how:
Sharing Office Scripts in Excel - Microsoft Support
Sharing Office Scripts in Excel. Applies To. Office Scripts can be shared with other users in your organization. When you share a script, you attach the script to the workbook, enabling others to view and run it. Important: Anyone who can edit a workbook can view and run its attached scripts.
Keeping leading zeros and large numbers - Microsoft Support
Tip: You can also click Special, and then select Zip Code, Zip Code + 4, Phone number, or Social Security Number. Find more information about custom codes, see Create or delete a custom number format .