From the course: Excel 2016: Advanced Formatting Techniques

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Build custom numeric formats

Build custom numeric formats

From the course: Excel 2016: Advanced Formatting Techniques

Start my 1-month free trial

Build custom numeric formats

“

- 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…

Contents