How do I permanently create a custom number format in Excel?
How do I create a custom date?
Vanity numbers, also referred to as custom phone numbers, are easy-to-remember, toll-free numbers. Custom vanity numbers start with an 8XX prefix. Currently, the available prefixes to choose from are: 800.
Select the cell or range of cells that you want to format. In the Format Cells dialog box, under Category, click Custom. At the bottom of the Type list, select the built-in format that you just created. For example, 000-000-0000.
How do I create a custom AutoFill list in Excel?
Create a custom date format
How do I create a custom date format in Excel?
Step 1: Select a number cell, right click and select Format Cells from the right-clicking menu. Step 2: In the popping Format Cells dialog box, go to Number tab, click to highlight the Custom in the Category box, type the custom format code into the Type box, and click the OK button.