PC Review


Reply
Thread Tools Rate Thread

Can't get NUMWORDS working in a formula field

 
 
Bill
Guest
Posts: n/a
 
      4th Jan 2008
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 With Quote
 
 
 
 
Peter Jamieson
Guest
Posts: n/a
 
      4th Jan 2008
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" <(E-Mail Removed)> wrote in message
news:BE60164C-8ADE-4B80-B858-(E-Mail Removed)...
> 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 With Quote
 
Bill
Guest
Posts: n/a
 
      4th Jan 2008
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" <(E-Mail Removed)> wrote in message
> news:BE60164C-8ADE-4B80-B858-(E-Mail Removed)...
> > 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 With Quote
 
SOORYA KARANTH
Guest
Posts: n/a
 
      23rd Apr 2009
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" <(E-Mail Removed)> wrote in message
> > news:BE60164C-8ADE-4B80-B858-(E-Mail Removed)...
> > > 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 With Quote
 
Peter Jamieson
Guest
Posts: n/a
 
      23rd Apr 2009
{ 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" <(E-Mail Removed)> wrote in message
>>> news:BE60164C-8ADE-4B80-B858-(E-Mail Removed)...
>>>> 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 With Quote
 
Graham Mayor
Guest
Posts: n/a
 
      23rd Apr 2009
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" <(E-Mail Removed)> wrote in message
>>> news:BE60164C-8ADE-4B80-B858-(E-Mail Removed)...
>>>> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using the field NUMWORDS in QuickParts Field ecn1942 Microsoft Word Document Management 6 24th Jan 2010 11:04 PM
NumWords field and Grammar Check discrepencies =?Utf-8?B?dG9waGVyOTgyNzI=?= Microsoft Word Document Management 2 8th Jul 2006 12:30 AM
NumWords field and Grammar Check discrepencies =?Utf-8?B?dG9waGVyOTgyNzI=?= Microsoft Word Document Management 0 8th Jul 2006 12:18 AM
Field with IF and nested formula not working Microsoft Word Document Management 1 14th May 2004 04:17 PM
Referencing a word field like NumWords in formula field ShikariShambu Microsoft Word New Users 1 8th Oct 2003 04:41 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:40 AM.