Microsoft Support

Microsoft Home Page

Sign in

Select the product you need help with

Select a solution

Create flexible, effective conditional formats in Excel 2007 - Excel - Office.com
Learn how to create flexible, effective conditional formats in Excel 2007.
Freeze or lock rows and columns
In Excel 2010, lock or freeze rows or columns to keep them in view, or split panes in your worksheet that can scroll separately from each other.
Can I create a custom format cells number
Can I create a custom format cells number using * / + or - for example
Create or delete a custom number format - Excel - Office.com
If a built-in number format does not meet your needs, you can create a new number format that is based on an existing number format and add it to the list of custom number formats
I need to create a custom format for a cell that looks like this: 01-A-AAA1000
I have exhausted all of the articles on creating a custom format, but I can't seem to get it right. I want my employees to be able to enter a job number that looks like this : 01AAAA1000 and have it