Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can't get NUMWORDS working in a formula field
I'm trying to round the number of words to the nearest hundred in my document
but keep getting an error when using the following formula: { = ROUND ({NUMWORDS], -3) } The error I receive is as follows: !Syntax Error, { If I replace {NUMWORDS} with an explicit number, the field works fine. I am running Word 2007. Any help is appreciated... |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can't get NUMWORDS working in a formula field
The special field braces {} that surround each field cannot be typed on the
keyboard. You can insert them using ctrl-F9. e.g. ctrl-F9: { } type NUMWORDS inside { NUMWORDS } select the file and press ctrl-F9: { { NUMWORDS } } type =ROUND after the first { : { =ROUND({ NUMWORDS } } type , -3) before the final } : { =ROUND({ NUMWORDS },-3) } -- Peter Jamieson http://tips.pjmsn.me.uk "Bill" wrote in message ... I'm trying to round the number of words to the nearest hundred in my document but keep getting an error when using the following formula: { = ROUND ({NUMWORDS], -3) } The error I receive is as follows: !Syntax Error, { If I replace {NUMWORDS} with an explicit number, the field works fine. I am running Word 2007. Any help is appreciated... |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can't get NUMWORDS working in a formula field
Of course - makes perfect sense. That worked great - thanks for the
assistance. "Peter Jamieson" wrote: The special field braces {} that surround each field cannot be typed on the keyboard. You can insert them using ctrl-F9. e.g. ctrl-F9: { } type NUMWORDS inside { NUMWORDS } select the file and press ctrl-F9: { { NUMWORDS } } type =ROUND after the first { : { =ROUND({ NUMWORDS } } type , -3) before the final } : { =ROUND({ NUMWORDS },-3) } -- Peter Jamieson http://tips.pjmsn.me.uk "Bill" wrote in message ... I'm trying to round the number of words to the nearest hundred in my document but keep getting an error when using the following formula: { = ROUND ({NUMWORDS], -3) } The error I receive is as follows: !Syntax Error, { If I replace {NUMWORDS} with an explicit number, the field works fine. I am running Word 2007. Any help is appreciated... |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can't get NUMWORDS working in a formula field
CAN I GET THE NUMBER CONVERTED TO WORD FOR EG., 123 TO ONE HUNDRED TWENTY
THREE? "Bill" wrote: Of course - makes perfect sense. That worked great - thanks for the assistance. "Peter Jamieson" wrote: The special field braces {} that surround each field cannot be typed on the keyboard. You can insert them using ctrl-F9. e.g. ctrl-F9: { } type NUMWORDS inside { NUMWORDS } select the file and press ctrl-F9: { { NUMWORDS } } type =ROUND after the first { : { =ROUND({ NUMWORDS } } type , -3) before the final } : { =ROUND({ NUMWORDS },-3) } -- Peter Jamieson http://tips.pjmsn.me.uk "Bill" wrote in message ... I'm trying to round the number of words to the nearest hundred in my document but keep getting an error when using the following formula: { = ROUND ({NUMWORDS], -3) } The error I receive is as follows: !Syntax Error, { If I replace {NUMWORDS} with an explicit number, the field works fine. I am running Word 2007. Any help is appreciated... |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can't get NUMWORDS working in a formula field
{ NUMWORDS \*CardText }
should take you up to a million words. Peter Jamieson http://tips.pjmsn.me.uk SOORYA KARANTH wrote: CAN I GET THE NUMBER CONVERTED TO WORD FOR EG., 123 TO ONE HUNDRED TWENTY THREE? "Bill" wrote: Of course - makes perfect sense. That worked great - thanks for the assistance. "Peter Jamieson" wrote: The special field braces {} that surround each field cannot be typed on the keyboard. You can insert them using ctrl-F9. e.g. ctrl-F9: { } type NUMWORDS inside { NUMWORDS } select the file and press ctrl-F9: { { NUMWORDS } } type =ROUND after the first { : { =ROUND({ NUMWORDS } } type , -3) before the final } : { =ROUND({ NUMWORDS },-3) } -- Peter Jamieson http://tips.pjmsn.me.uk "Bill" wrote in message ... I'm trying to round the number of words to the nearest hundred in my document but keep getting an error when using the following formula: { = ROUND ({NUMWORDS], -3) } The error I receive is as follows: !Syntax Error, { If I replace {NUMWORDS} with an explicit number, the field works fine. I am running Word 2007. Any help is appreciated... |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Can't get NUMWORDS working in a formula field
Use a cardtext switch - http://www.gmayor.com/formatting_word_fields.htm
{ =123 \*cardtext } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SOORYA KARANTH wrote: CAN I GET THE NUMBER CONVERTED TO WORD FOR EG., 123 TO ONE HUNDRED TWENTY THREE? "Bill" wrote: Of course - makes perfect sense. That worked great - thanks for the assistance. "Peter Jamieson" wrote: The special field braces {} that surround each field cannot be typed on the keyboard. You can insert them using ctrl-F9. e.g. ctrl-F9: { } type NUMWORDS inside { NUMWORDS } select the file and press ctrl-F9: { { NUMWORDS } } type =ROUND after the first { : { =ROUND({ NUMWORDS } } type , -3) before the final } : { =ROUND({ NUMWORDS },-3) } -- Peter Jamieson http://tips.pjmsn.me.uk "Bill" wrote in message ... I'm trying to round the number of words to the nearest hundred in my document but keep getting an error when using the following formula: { = ROUND ({NUMWORDS], -3) } The error I receive is as follows: !Syntax Error, { If I replace {NUMWORDS} with an explicit number, the field works fine. I am running Word 2007. Any help is appreciated... |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
word field formula | Mailmerge | |||
NumWords field and Grammar Check discrepencies | Microsoft Word Help | |||
Merge field delimiter in insert field formula ? | Mailmerge | |||
Numwords Field in a Cell | Tables | |||
field formula | Tables |