View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ward376 ward376 is offline
external usenet poster
 
Posts: 360
Default Auto number for a parts list.

If I understand your question correctly, you can increment these
numbers by dragging the fill handle - enter MJCF1/2-001 in a cell,
then put the mouse pointer over the little box in the lower right
corner of the cell until the cursor changes, left-click and drag
down.

Cliff Edwards