- In addition to the many built-in numeric formats…that we see in Excel, you can also create your own.…Now, I don't want to make this sound…like a make-work project, but there could be times…when you have a certain look in mind.…Some of these might be like…what we're seeing in columns E and G here.…Let's first take a look at column B, though.…Maybe your company uses an ID number…and for years the scheme you've used is,…because it's a seven digit number it's going to be easier…to read if we put a dash in after the third character…between the third and fourth characters there.…So, let's create a format for this.…

Column B is selected.…We can go to Format Cells.…I'll right-click and go to Format Cells.…Remember, Control + 1 works also.…And we can go immediately to Custom.…Now, if you start to scroll through this list,…you're probably going to be a little bit overwhelmed.…It is not important to understand every single one of these.…Some of the larger books on Excel go into great detail…about what these different symbols mean.…

Resume Transcript Auto-Scroll

Author

Released

2/18/2016

Get simple, powerful tips for making spreadsheet information readable and understandable in Microsoft Excel 2016. Dennis Taylor shows how to emphasize specific cells with fonts, borders, and color; adjust the positioning of cell contents; format numeric data; and add style and readability to worksheets. You'll also learn how to add pictures to worksheets and discover automation techniques (including conditional formatting) that take the drudgery out of formatting even the largest amounts of data.