If you have a list of values that come from a database and want to format them in Excel using a special number format like a Zip Code, Social Security Number or Phone Number, then this is possible using the Format Cells dialogue box and choosing the “Special” number category.

To activate this selection you need to make sure that your Locale (location) is set to English (U.S)

See how easy this is achieved in just a few simple steps.

DOWNLOAD WORKBOOK

Number Formats - Special

HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Pivot Table Count Transactions The default Value Field Setting when analyzing data with a Pivot Table is to Sum, but you can also analyze a Pivot Table with a Count.This is useful when you want to see how many sales transactions  took place within a region, a month, a year or per business unit.DOWNLOAD...
Rank Largest to Smallest With Excel Pivot Tables Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the RANK LARGEST TO SMALLEST calculation.This option will immediately calculate the rankings (1 being the LARGEST value) for your values, allowing you to pi...
Excel Table Slicers Slicers were introduced with Pivot Tables in Excel 2010 and they allowed us to select items to filter with beautiful interactive buttons.You can see the power of Slicers and the different ways you can format them in these posts: https://www.myexcelonline.com/category/pivot-ta...
Copy The Cell Above In Excel Sometimes we get data that is downloaded from an external source and it is not formatted properly.You may have cells with missing data and cases where you want to copy the cell directly above to fill in your empty cell in Excel.This can be achieved with the following step...