Creating custom formats


show more Creating custom formats provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Creating custom formats

Not only does Excel have a wealth of built-in formats for various numbers and text entries, you also have the ability to create your own formats. Let's look at some data from a couple of different perspectives. You may have noticed this column here, column D Social Security number, column E phone numbers. Both of these examples here show that data not being formatted. I think almost anybody would say this is not as easier to read as it could be and should be. Right-click Format Cells or press Ctrl+ 1. Built-in as an automatic format you don't have to create any kind of custom format here, in the category called Special you'll see Social Security Number. Use it! Don't type the hyphens.

Ideally if you are setting up a field to contain Social Security numbers, format this before the data goes in. And when you make your data entries, do not type the hyphens. The format is there. You look in the Formula bar, you don't see the hyphens. Same idea with the phone number. Right-...

Creating custom formats
Video duration: 6m 23s 3h 43m Intermediate

Viewers:

Creating custom formats provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...