Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Auto number for a parts list.

I want to auto number a parts list . How do you do that with part text and
part number. Example ( MJCF1/2-001,MJCF1/2-002,MJCF1/2-003)

How could I auto number this way?
  #2   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you auto-number a large list of rows in Excel? Birdieguy Excel Discussion (Misc queries) 23 May 25th 09 10:56 PM
Formula needed for my parts list Krystal Excel Discussion (Misc queries) 0 June 23rd 08 07:58 PM
Printing selected parts of a list.... Daniel R Excel Worksheet Functions 2 April 4th 07 03:40 AM
Dependant parts list -lookup BEEZ Excel Discussion (Misc queries) 3 October 8th 05 12:37 PM
Auto repeate parts of functions [email protected] Excel Worksheet Functions 2 August 18th 05 11:09 PM


All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"