Can't get NUMWORDS working in a formula field

[Bill]

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...

 

[Peter Jamieson]

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) }

 

[Bill]

Of course - makes perfect sense. That worked great - thanks for the
assistance.

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

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...

 

[SOORYA KARANTH]

CAN I GET THE NUMBER CONVERTED TO WORD FOR EG., 123 TO ONE HUNDRED TWENTY
THREE?

Of course - makes perfect sense. That worked great - thanks for the
assistance.

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

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...

 

[Peter Jamieson]

{ NUMWORDS \*CardText }

should take you up to a million words.

Peter Jamieson

http://tips.pjmsn.me.uk

CAN I GET THE NUMBER CONVERTED TO WORD FOR EG., 123 TO ONE HUNDRED TWENTY
THREE?

Of course - makes perfect sense. That worked great - thanks for the
assistance.

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

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...

 

[Graham Mayor]

Use a cardtext switch - http://www.gmayor.com/formatting_word_fields.htm
{ =123 \*cardtext }

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

CAN I GET THE NUMBER CONVERTED TO WORD FOR EG., 123 TO ONE HUNDRED
TWENTY THREE?

Of course - makes perfect sense. That worked great - thanks for the
assistance.

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

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...