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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Custom Number Formats in Excel A custom number format in Excel can have up to four different sections in the following order: Positive format; Negative format; Zero format; Text format   You can specify different format codes for each section as long as they are separated by a semicolon. So you ca...
How To Make Negative Red Numbers In Excel When you are working with lots of different numbers in Excel, you sometimes want your numbers to stand out by showing them in a negative red number with a minus sign in the front. To do this you need to select your numbers and press CTRL+1 to bring up the Format dialogue box. ...
Split First & Last Name Using Text to Columns There are times when you receive a data set of employee full names in one column and you want to separate the full name into first name and surname in separate columns. One way is to use the Power Query method, which is great if you have lots of data that gets added each day, ...
Find Blank Cells In Excel With A Color In Excel you can have a data set that comes from an external source which isn't always formatted to your liking. One of the most common things you may encounter are blank cells in your Excel data which can hinder your analysis, especially if you are using a Pivot Table to anal...