From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

Unlock the full course today

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

Create custom number formats

Create custom number formats

From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

Start my 1-month free trial

Create custom number formats

“

- [Instructor] Custom number formats control how numbers are displayed in our workbook, no matter how they are entered. After watching this video, you'll know how to create custom date formats, number formats, and how to combine and create a custom number and text format. Let's take a look at our custom formats workbook, and I want to start off by looking at the Custom Date and Number Examples worksheet that I've included. I have gone through and created several custom date formats, number formats, and custom formats that include text. You will see these if you click on the Number Format button and click on Custom. Scroll down to the bottom, because any time you add a custom format, it's going to show up at the bottom of the custom list. So for example, the first one that I'm showing you, is right here, the code is four y's, and if I type in 11232019, it will be displayed as showing only the year. The custom code for…

Contents