 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Help please with generating a number sequence.
Hi , i was wondering , is it possible to generate a number sequence , for example i have 100 items , i need to have them numbered as focus-00001 through to focus-00100 , is there a command in excel that would allow this , also when i add to the list , i would like to be able to say add another 85 items , then i would like to generate focus-00101 through to focus-00185 I presume this will be a equation , but i'm unsure how to do this. Hi Dave No need for any formulae Enter focus-00001 in cell A1, grab the fill handle (small black cross when you hover over the bottom right corner of the cell) and drag down. Excel will increment the last number for you.  SignatureRegards Roger Govier > Hi , i was wondering , is it possible to generate a number sequence , > for example i have 100 items , i need to have them numbered as [quoted text clipped - 4 lines] > > I presume this will be a equation , but i'm unsure how to do this. If your data starts on row 2, allowing row 1 to contain headers, then you can put this formula in A2: ="focus-"&TEXT(ROW()-1,"00000") and copy down the column to row 186. You can fix these values by highlighting the column, then <copy>, then Edit | Paste Special | Values (check) | OK then <Esc>. Hope this helps. Pete > Hi , i was wondering , is it possible to generate a number sequence , for > example i have 100 items , i need to have them numbered as focus-00001 [quoted text clipped - 3 lines] > > I presume this will be a equation , but i'm unsure how to do this. > Hi , i was wondering , is it possible to generate a number sequence , for > example i have 100 items , i need to have them numbered as focus-00001 > through to focus-00100 , is there a command in excel that would allow this > , also when i add to the list , i would like to be able to say add another > 85 items , then i would like to generate focus-00101 through to > focus-00185 Can you make use of this technique? Place focus-00001 in your starting cell. Place focus-00002 in the cell underneath your starting cell. Select both cells and look at the bottom right corner of the selection. Do you see the small, black square? Place your cursor over it until the cursor turns into a thin, solid black plus sign (or cross)... click with the left mouse button and drag down. Let go of the mouse button and see what happens. You can continue the series by selecting the bottom two cells in the column and repeating the process outlined above. Simply click/drag down through as many cells as you need to. Rick >> Hi , i was wondering , is it possible to generate a number sequence , for >> example i have 100 items , i need to have them numbered as focus-00001 [quoted text clipped - 14 lines] > > Rick Hi , thank you all for your help , yes the pulling down of the cross does the trick :) i do have 1 more rather more complicated question to ask , which i will put into another subject....
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.