Word question

LoganSaj

New Member
Joined
Aug 27, 2007
Messages
27
I'm not sure if this is the correct forum, but ...

Is there a way to have a document word count appear at the top (not in header) of a Word 2007/2003 document?
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Hi LoganSaj,

Select your insertion point, then:
. press Ctrl-F9 twice, to create a pair of nested field braces - they'll look like '{ { } }'
. fill in/around the field braces so that you end up with '{={NUMWORDS}-1}'
. select the field and press F9 twice.

In theory, a NUMWORDS field alone (ie {NUMWORDS}) should suffice but what happens in practice is that, after the first update, the NUMWORDS field includes itself in the count.

Note: The count returned by a NUMWORDS field will not include page headers, page footers, footnotes or endnotes, but it will the include footnote & endnote reference numbers. Hidden text is only counted if your print options are set to print hidden text.
 
Upvote 0
Hi LoganSaj,

Select your insertion point, then:
. press Ctrl-F9 twice, to create a pair of nested field braces - they'll look like '{ { } }'
. fill in/around the field braces so that you end up with '{={NUMWORDS}-1}'
. select the field and press F9 twice.

Great! That works. Now, is there a way to format the number result with commas (eg., 43,330), or to round to the nearest 100 for results over 1000?
 
Last edited:
Upvote 0
For the commas try adding a switch to the field.

{ NUMWORDS \# #,###,### }
 
Upvote 0
Hi folks,

All you need for the thousands separator is:
{={NUMWORDS}-1 \# ,0}
Having Norie's \# #,###,### simply pads out the space before the number if it's less than 1,000,000
 
Upvote 0
Hi LoganSaj,

The formula in that post rounds to the nearest 1,000 and doesn't concern itself with whether the number is greater than 1,000, as you indicated was the alternative result:
is there a way to format the number result with commas (eg., 43,330), or to round to the nearest 100 for results over 1000?
For that you need something considerably more sophisticated:
{=IF({NUMWORDS}>999,ROUND({NUMWORDS}-1,-2),{NUMWORDS}-1) \# ,0}
 
Upvote 0
LoganSaj

Would you care to actually post the solution you found here?
 
Upvote 0

Forum statistics

Threads
1,225,432
Messages
6,184,955
Members
453,270
Latest member
jgRSLCaUNQtW

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top