Number Separator in Word 2000

Microsoft Word 2000
November 25, 2009 at 20:23:56
Specs: Windows XP, 1GB
How can i display a number in Word 2000 automatically in comma separator format, example:

Suppose i merge my data into Word 2000, i want to display it with commas like, 2,200.00 and so on. Is there any control or function available?

See More: Number Separator in Word 2000

Report •

November 26, 2009 at 06:50:41

From MS Help file:

To control other aspects of formatting, press ALT+F9 to display field codes in the main document, and then add switches to the merge fields.

For example:

To display the number "34987.89" as "$34,987.89," add a numeric picture switch (\# $#,###.00).


Report •

December 3, 2009 at 21:42:39
Where should i put the switch. I tried putting after first and then before the merge field. I must be doing something wrong. I even tried pressing Alt+F9 and the same thing. just cannot get it.

«BP» «DP» «DA»
These are the merge fields for example i got. Please give me another example.

And this is how it looks after ALT+F9

Report •

December 4, 2009 at 05:08:23

Here is an example of a field code (a formula in this case) with a numeric format applied:
{=9*1000000 \# #,000}
which looks like this when you toggle the field code again

If you have a mergefield with the field name BP, and the field you are merging is numeric, you will not see the format until you have run the merge and there is numeric data in the field.

It is a long time since I used the merge process, so I cannot remember all the details.
However you do require a data source, such as an Excel workbook, or another database, with the named fields which contain the data that will be entered in the mergefields, producing a series of documents that are identical except for the contents of the merged fields.

Help states that a mergefield name is 'The name of a data field listed in the header record of the selected data source. The field name must exactly match the field name in the header record'.

Here is a mergefield with formatting

DA is the mergefield name
\* MERGEFORMAT ensures that the format you have specified is applied to each record that is merged.


Report •

Related Solutions

December 4, 2009 at 18:39:18
Thanks Humar for the time and trouble you have taken.... it worked great. Thanks for the examples, that was really time consuming for you, but it sure made things easy for me.

Thanks once more.

Report •

December 5, 2009 at 12:45:01
You're welcome



Report •

Ask Question