If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automatic numbering in column
I want to have numbering appear automatically in a column. My numbering is
like 06-01 then 06-02, 06-03 etc. Can anyone assist in how I set this up. TIA |
#2
|
|||
|
|||
Automatic numbering in column
Please provide more detail about where the 06 comes from. The rest is
simple. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Slow Learner" wrote in message ... I want to have numbering appear automatically in a column. My numbering is like 06-01 then 06-02, 06-03 etc. Can anyone assist in how I set this up. TIA |
#3
|
|||
|
|||
Automatic numbering in column
Hi Suzanne
The 06 represents the current year. Next year the numbering will start at 07-0001 etc. TFHIA "Suzanne S. Barnhill" wrote: Please provide more detail about where the 06 comes from. The rest is simple. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Slow Learner" wrote in message ... I want to have numbering appear automatically in a column. My numbering is like 06-01 then 06-02, 06-03 etc. Can anyone assist in how I set this up. TIA |
#4
|
|||
|
|||
Automatic numbering in column
Use the following code in a macro to insert numbers such as that in the
cells in the first column of the table in which the selection is located: Dim i As Long With Selection.Tables(1) For i = 1 To .Rows.Count .Cell(i, 1).Range.Text = "06-" & Format(i, "00#") Next i End With If you don't want a number in the first row, use Dim i As Long With Selection.Tables(1) For i = 2 To .Rows.Count .Cell(i, 1).Range.Text = "06-" & Format(i - 1, "00#") Next i End With -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Slow Learner" wrote in message ... Hi Suzanne The 06 represents the current year. Next year the numbering will start at 07-0001 etc. TFHIA "Suzanne S. Barnhill" wrote: Please provide more detail about where the 06 comes from. The rest is simple. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Slow Learner" wrote in message ... I want to have numbering appear automatically in a column. My numbering is like 06-01 then 06-02, 06-03 etc. Can anyone assist in how I set this up. TIA |
#5
|
|||
|
|||
Automatic numbering in column
Assuming that you want the numbering to be 06-01, 06-02, ... 06-10, 06-11,
.... 06-99, 06-100, you create a numbered style (or apply numbering to the existing style) as follows: 1. Format | Style [your style] | Modify | Format: Numbering. 2. Choose 01, 02, 03 as the "Number style" and type in 06- in front of the number field in the "Number format" box. OK. 3. Apply the style to the column in question. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Slow Learner" wrote in message ... Hi Suzanne The 06 represents the current year. Next year the numbering will start at 07-0001 etc. TFHIA "Suzanne S. Barnhill" wrote: Please provide more detail about where the 06 comes from. The rest is simple. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Slow Learner" wrote in message ... I want to have numbering appear automatically in a column. My numbering is like 06-01 then 06-02, 06-03 etc. Can anyone assist in how I set this up. TIA |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
turn off automatic numbering; keep existing numbering | Liz | General Discussion | 1 | March 14th, 2006 09:34 PM |
Need to Improve Code Copying/Pasting Between Workbooks | David | General Discussion | 1 | January 6th, 2006 03:56 AM |
Positioning Numeric Values Resulting from 6 Column Array Formula | Sam via OfficeKB.com | Worksheet Functions | 2 | January 5th, 2006 02:03 AM |
Return Count for LAST NonBlank Cell in each Row | Sam via OfficeKB.com | Worksheet Functions | 12 | April 17th, 2005 10:36 PM |
Column E cell contents added into Column D contents (not overwriting data but mixing) | creativetechguy | General Discussion | 2 | August 5th, 2004 07:32 PM |