Gordon wrote:
Gord Dibben wrote:
Enter 2005-001 in A1

Right-click on A1 and drag down column A to A550.

Interesting. In Excel 2002, right-clicking brings up the context menu
and you CAN'T drag down the column.

Ah. You have to right click on the CORNER of the cell, where the cursor
changes to a "+"