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
|
|||
|
|||
Auto Number
I have a table that has a column of numbers. The first cell in the column
starts with 0800. In the cells below that I want the numbers to run in sequence. ex: 0801, 0802, 0803, etc. Is there a way of just typing 0800 in the first cell and placing a formula in the cells below so the numbers auto populate? Or something similiar to the fill handle in Excel. Thank you |
#2
|
|||
|
|||
Auto Number
Can you not just apply numbering to the column, starting at 800?
-- Enjoy, Tony "Karen" wrote in message ... I have a table that has a column of numbers. The first cell in the column starts with 0800. In the cells below that I want the numbers to run in sequence. ex: 0801, 0802, 0803, etc. Is there a way of just typing 0800 in the first cell and placing a formula in the cells below so the numbers auto populate? Or something similiar to the fill handle in Excel. Thank you |
#3
|
|||
|
|||
Auto Number
How can I apply numbering? Do you mean like bullet points? These numbers
are in tables. Don't you have to hit the enter key in this case in order for the number to advance to the next number? Thank you, Karen "Tony Jollans" wrote: Can you not just apply numbering to the column, starting at 800? -- Enjoy, Tony "Karen" wrote in message ... I have a table that has a column of numbers. The first cell in the column starts with 0800. In the cells below that I want the numbers to run in sequence. ex: 0801, 0802, 0803, etc. Is there a way of just typing 0800 in the first cell and placing a formula in the cells below so the numbers auto populate? Or something similiar to the fill handle in Excel. Thank you |
#4
|
|||
|
|||
Auto Number
Enter the following field in the first row
{ SEQ MySeq r\ 0800 \# 0###} Paste the following field in the subsequent rows { SEQ MySeq \# 0###} The field code delimiters { } are entered with CTRL+F9 |
#5
|
|||
|
|||
Auto Number
Select the column and apply numbering via Format | Bullets and Numbering.
Set the starting number to 800. -- 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. "Karen" wrote in message ... How can I apply numbering? Do you mean like bullet points? These numbers are in tables. Don't you have to hit the enter key in this case in order for the number to advance to the next number? Thank you, Karen "Tony Jollans" wrote: Can you not just apply numbering to the column, starting at 800? -- Enjoy, Tony "Karen" wrote in message ... I have a table that has a column of numbers. The first cell in the column starts with 0800. In the cells below that I want the numbers to run in sequence. ex: 0801, 0802, 0803, etc. Is there a way of just typing 0800 in the first cell and placing a formula in the cells below so the numbers auto populate? Or something similiar to the fill handle in Excel. Thank you |
#6
|
|||
|
|||
Auto Number
The simplest way - leave the column blank, select it, and click on the
numbering button - yes just like bullets - and then format the numbers to start at what you want - once set it will be automatically included on added rows. Of course, using a proper numbered style would be a lot better. -- Enjoy, Tony "Karen" wrote in message ... How can I apply numbering? Do you mean like bullet points? These numbers are in tables. Don't you have to hit the enter key in this case in order for the number to advance to the next number? Thank you, Karen "Tony Jollans" wrote: Can you not just apply numbering to the column, starting at 800? -- Enjoy, Tony "Karen" wrote in message ... I have a table that has a column of numbers. The first cell in the column starts with 0800. In the cells below that I want the numbers to run in sequence. ex: 0801, 0802, 0803, etc. Is there a way of just typing 0800 in the first cell and placing a formula in the cells below so the numbers auto populate? Or something similiar to the fill handle in Excel. Thank you |
#7
|
|||
|
|||
Auto Number
Thank you for your help - Are these the step-by-step instructions?
I press CTRL+F9 to enter the field code delimiters Type SEQ MySeq r\ 0800 \# 0### in between the braces Paste { SEQ MySeq \# 0###} in the subsequent rows Then what do I do? "Greg" wrote: Enter the following field in the first row { SEQ MySeq r\ 0800 \# 0###} Paste the following field in the subsequent rows { SEQ MySeq \# 0###} The field code delimiters { } are entered with CTRL+F9 |
#8
|
|||
|
|||
Auto Number
Thank you - I just did what you suggested and it works, although I need the
two leading zeros in front of the numbers. Example: 00843, 00844, etc. In the "Customize Numbered List" when I enter "00843" to start at that number, it removes the leading zeros. HELP! "Suzanne S. Barnhill" wrote: Select the column and apply numbering via Format | Bullets and Numbering. Set the starting number to 800. -- 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. "Karen" wrote in message ... How can I apply numbering? Do you mean like bullet points? These numbers are in tables. Don't you have to hit the enter key in this case in order for the number to advance to the next number? Thank you, Karen "Tony Jollans" wrote: Can you not just apply numbering to the column, starting at 800? -- Enjoy, Tony "Karen" wrote in message ... I have a table that has a column of numbers. The first cell in the column starts with 0800. In the cells below that I want the numbers to run in sequence. ex: 0801, 0802, 0803, etc. Is there a way of just typing 0800 in the first cell and placing a formula in the cells below so the numbers auto populate? Or something similiar to the fill handle in Excel. Thank you |
#9
|
|||
|
|||
Auto Number
Thank you - I just did what you suggested and it works, although I need the
two leading zeros in front of the numbers. Example: 00843, 00844, etc. In the "Customize Numbered List" when I enter "00843" to start at that number, it removes the leading zeros. HELP! "Tony Jollans" wrote: The simplest way - leave the column blank, select it, and click on the numbering button - yes just like bullets - and then format the numbers to start at what you want - once set it will be automatically included on added rows. Of course, using a proper numbered style would be a lot better. -- Enjoy, Tony "Karen" wrote in message ... How can I apply numbering? Do you mean like bullet points? These numbers are in tables. Don't you have to hit the enter key in this case in order for the number to advance to the next number? Thank you, Karen "Tony Jollans" wrote: Can you not just apply numbering to the column, starting at 800? -- Enjoy, Tony "Karen" wrote in message ... I have a table that has a column of numbers. The first cell in the column starts with 0800. In the cells below that I want the numbers to run in sequence. ex: 0801, 0802, 0803, etc. Is there a way of just typing 0800 in the first cell and placing a formula in the cells below so the numbers auto populate? Or something similiar to the fill handle in Excel. Thank you |
#10
|
|||
|
|||
Auto Number
Sorry, Karen, but I don't believe that's possible. You'll need to define a
custom number sequence field for that. -- Enjoy, Tony "Karen" wrote in message ... Thank you - I just did what you suggested and it works, although I need the two leading zeros in front of the numbers. Example: 00843, 00844, etc. In the "Customize Numbered List" when I enter "00843" to start at that number, it removes the leading zeros. HELP! "Tony Jollans" wrote: The simplest way - leave the column blank, select it, and click on the numbering button - yes just like bullets - and then format the numbers to start at what you want - once set it will be automatically included on added rows. Of course, using a proper numbered style would be a lot better. -- Enjoy, Tony "Karen" wrote in message ... How can I apply numbering? Do you mean like bullet points? These numbers are in tables. Don't you have to hit the enter key in this case in order for the number to advance to the next number? Thank you, Karen "Tony Jollans" wrote: Can you not just apply numbering to the column, starting at 800? -- Enjoy, Tony "Karen" wrote in message ... I have a table that has a column of numbers. The first cell in the column starts with 0800. In the cells below that I want the numbers to run in sequence. ex: 0801, 0802, 0803, etc. Is there a way of just typing 0800 in the first cell and placing a formula in the cells below so the numbers auto populate? Or something similiar to the fill handle in Excel. Thank you |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I change a field property from text to Auto number? | Joyce | General Discussion | 5 | October 21st, 2005 05:55 PM |
Help to append flat file table to two tables | Victoriya F via AccessMonster.com | Running & Setting Up Queries | 11 | September 26th, 2005 05:30 PM |
Auto Number. Won't let user enter new record | Connie | General Discussion | 1 | April 4th, 2005 06:23 PM |
HOW CAN I CHANGE THE CONTACT ID AUTO NUMBER TO MY OWN NUMBER SYSTE | PC | General Discussion | 1 | September 25th, 2004 01:58 AM |
Auto paragraph number - then remove auto | Legalbits | General Discussion | 2 | May 17th, 2004 08:11 PM |