If you want your data to have leading text in each cell, i.e. ACCT - 12345, without typing the text each time, set up Custom formatting!
- In Excel, select all the blank cells where you want to apply the custom format.
- Press CTRL+1 (to open the Format cells dialog box).
- Select Custom from the Category list.
- Under Type, enter the text you want to automatically display followed by the minimum quantity of numbers (represented by zeros).
- Click OK.
- Now try typing just the numbers in the cells. The text should automatically display!
