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
|
|||
|
|||
LISTNUM formatting problem
I need to create a field that will number a list using the format: URS-001,
URS-002, etc. I used the formula: {LISTNUM "sequence 1" \# 000}. It works until I get to 10, which comes out as URS-0010, but needs to be URS-010. How do I achieve this? |
#2
|
|||
|
|||
LISTNUM formatting problem
Frankly I can't get Listnum to produce anything like what you have - however
{ SEQ "SEQUENCE 1" \# "URS'-'000" } should work. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Joyce wrote: I need to create a field that will number a list using the format: URS-001, URS-002, etc. I used the formula: {LISTNUM "sequence 1" \# 000}. It works until I get to 10, which comes out as URS-0010, but needs to be URS-010. How do I achieve this? |
#3
|
|||
|
|||
LISTNUM formatting problem
Thanks, however it produces the same result when it gets to multiple digit
numbers (i.e., URS-0010, etc.). "Graham Mayor" wrote: Frankly I can't get Listnum to produce anything like what you have - however { SEQ "SEQUENCE 1" \# "URS'-'000" } should work. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Joyce wrote: I need to create a field that will number a list using the format: URS-001, URS-002, etc. I used the formula: {LISTNUM "sequence 1" \# 000}. It works until I get to 10, which comes out as URS-0010, but needs to be URS-010. How do I achieve this? |
#4
|
|||
|
|||
LISTNUM formatting problem
It works correctly here. I can see no reason why it shouldn't work. What
does { =10 \# "000" } produce for you? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Joyce wrote: Thanks, however it produces the same result when it gets to multiple digit numbers (i.e., URS-0010, etc.). "Graham Mayor" wrote: Frankly I can't get Listnum to produce anything like what you have - however { SEQ "SEQUENCE 1" \# "URS'-'000" } should work. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Joyce wrote: I need to create a field that will number a list using the format: URS-001, URS-002, etc. I used the formula: {LISTNUM "sequence 1" \# 000}. It works until I get to 10, which comes out as URS-0010, but needs to be URS-010. How do I achieve this? |
#5
|
|||
|
|||
LISTNUM formatting problem
I'm sorry. I didn't notice that you switched the field type to SEQ.
Interestingly enough, when I employ SEQ as you stated in your first example, { SEQ "SEQUENCE 1" \# "URS'-'000" } it displays URS-001. When inserted a second time however, the result remains URS-001 instead of advancing to URS-002. I entered your most recent suggestion { =10 \# "000" }. When I use it with LISTNUM, I get (1), which advances. When I use it with SEQ, I get errors. Also, sometimes Word automatically inserts \* MERGEFORMAT, which doesn't seem to do anything good. Any thoughts? Am I misinterpreting what you're saying? Does the field definition have anything to do with the style employed at the time? "Graham Mayor" wrote: It works correctly here. I can see no reason why it shouldn't work. What does { =10 \# "000" } produce for you? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Joyce wrote: Thanks, however it produces the same result when it gets to multiple digit numbers (i.e., URS-0010, etc.). "Graham Mayor" wrote: Frankly I can't get Listnum to produce anything like what you have - however { SEQ "SEQUENCE 1" \# "URS'-'000" } should work. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Joyce wrote: I need to create a field that will number a list using the format: URS-001, URS-002, etc. I used the formula: {LISTNUM "sequence 1" \# 000}. It works until I get to 10, which comes out as URS-0010, but needs to be URS-010. How do I achieve this? |
#6
|
|||
|
|||
LISTNUM formatting problem
There are a few misconceptions here.
I could not get ListNum to produce anything like what you wanted, but a SEQ field will, hence the change (I did mention this earlier).. You will need to update the fields to show the correct numbers - for this purpose you may find the macro at http://www.gmayor.com/installing_macro.htm useful as it will update all fields at a click. { =10 \# "000" } is a formula field. CTRL+F9 for the brackets then type the rest. It is nothing to do with list numbers or SEQ fields, but simply to see what happens to the switch. It should show 010. If it doesn't we are struggling a bit Word inserts \*Mergeformat by default if you insert fields from the insert field dialog and do not uncheck the 'preserve formatting' check box in that dialog. It is usually quicker to manually enter the fields from the keyboard using CTRL+F9 for each pair of brackets {} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Joyce wrote: I'm sorry. I didn't notice that you switched the field type to SEQ. Interestingly enough, when I employ SEQ as you stated in your first example, { SEQ "SEQUENCE 1" \# "URS'-'000" } it displays URS-001. When inserted a second time however, the result remains URS-001 instead of advancing to URS-002. I entered your most recent suggestion { =10 \# "000" }. When I use it with LISTNUM, I get (1), which advances. When I use it with SEQ, I get errors. Also, sometimes Word automatically inserts \* MERGEFORMAT, which doesn't seem to do anything good. Any thoughts? Am I misinterpreting what you're saying? Does the field definition have anything to do with the style employed at the time? "Graham Mayor" wrote: It works correctly here. I can see no reason why it shouldn't work. What does { =10 \# "000" } produce for you? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Joyce wrote: Thanks, however it produces the same result when it gets to multiple digit numbers (i.e., URS-0010, etc.). "Graham Mayor" wrote: Frankly I can't get Listnum to produce anything like what you have - however { SEQ "SEQUENCE 1" \# "URS'-'000" } should work. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Joyce wrote: I need to create a field that will number a list using the format: URS-001, URS-002, etc. I used the formula: {LISTNUM "sequence 1" \# 000}. It works until I get to 10, which comes out as URS-0010, but needs to be URS-010. How do I achieve this? |
#7
|
|||
|
|||
LISTNUM formatting problem
Thanks. It seems to be working now. I also got the formula you provided to
produce the same results as you got. I thought I did the SEQ formula the same as you did, but now at least, it's working. Thanks for the macro, too. "Graham Mayor" wrote: There are a few misconceptions here. I could not get ListNum to produce anything like what you wanted, but a SEQ field will, hence the change (I did mention this earlier).. You will need to update the fields to show the correct numbers - for this purpose you may find the macro at http://www.gmayor.com/installing_macro.htm useful as it will update all fields at a click. { =10 \# "000" } is a formula field. CTRL+F9 for the brackets then type the rest. It is nothing to do with list numbers or SEQ fields, but simply to see what happens to the switch. It should show 010. If it doesn't we are struggling a bit Word inserts \*Mergeformat by default if you insert fields from the insert field dialog and do not uncheck the 'preserve formatting' check box in that dialog. It is usually quicker to manually enter the fields from the keyboard using CTRL+F9 for each pair of brackets {} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Joyce wrote: I'm sorry. I didn't notice that you switched the field type to SEQ. Interestingly enough, when I employ SEQ as you stated in your first example, { SEQ "SEQUENCE 1" \# "URS'-'000" } it displays URS-001. When inserted a second time however, the result remains URS-001 instead of advancing to URS-002. I entered your most recent suggestion { =10 \# "000" }. When I use it with LISTNUM, I get (1), which advances. When I use it with SEQ, I get errors. Also, sometimes Word automatically inserts \* MERGEFORMAT, which doesn't seem to do anything good. Any thoughts? Am I misinterpreting what you're saying? Does the field definition have anything to do with the style employed at the time? "Graham Mayor" wrote: It works correctly here. I can see no reason why it shouldn't work. What does { =10 \# "000" } produce for you? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Joyce wrote: Thanks, however it produces the same result when it gets to multiple digit numbers (i.e., URS-0010, etc.). "Graham Mayor" wrote: Frankly I can't get Listnum to produce anything like what you have - however { SEQ "SEQUENCE 1" \# "URS'-'000" } should work. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Joyce wrote: I need to create a field that will number a list using the format: URS-001, URS-002, etc. I used the formula: {LISTNUM "sequence 1" \# 000}. It works until I get to 10, which comes out as URS-0010, but needs to be URS-010. How do I achieve this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formatting and Macro Problem | maacmaac | General Discussion | 0 | October 7th, 2005 04:30 PM |
Conditioal formatting problem | HDV | General Discussion | 3 | September 22nd, 2005 03:04 PM |
problem finding conditional formatting! | Kieran the Fish | Setting Up & Running Reports | 4 | August 24th, 2005 11:45 AM |
Formatting problem | Henry | General Discussion | 11 | June 25th, 2005 01:20 AM |
Access report to Word-Conditional Formatting problem | laralea | General Discussion | 1 | May 17th, 2005 06:36 PM |