From the course: Microsoft Office Specialist: Expert (Office 365 and Office 2019) Cert Prep

Unlock the full course today

Join today to access over 25,200 courses taught by industry experts.

Create custom number formats

Create custom number formats

From the course: Microsoft Office Specialist: Expert (Office 365 and Office 2019) Cert Prep

Start my 1-month free trial Buy for my team

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