Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Alex Hammerstein Alex Hammerstein is offline
external usenet poster
 
Posts: 18
Default Mail merge formatting numbers

Hi



Within a mail merge I am trying to limit a number to a whole number. The
data is showing as a whole number in the datasource with the properties
shown as Fixed no places of decimal.

The data in the mail merge is running to umpteen places of decimal. I have
tried adding the switch \### but that is not working.

Can someone help me please

Many thanks

A

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Mail merge formatting numbers

Hi Alex,

In Word:
.. select the field;
.. press Ctrl-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
.. edit the field so that you get {MERGEFIELD MyData \# 0};
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Note: the precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'.

If you add a final ';' to the formatting switch (eg \# 0;-0 zero values will be suppressed. This suppresses 0s resulting from
empty fields and from fields containing 0s.

--
Cheers
macropod
[MVP - Microsoft Word]


"Alex Hammerstein" wrote in message ...
Hi



Within a mail merge I am trying to limit a number to a whole number. The
data is showing as a whole number in the datasource with the properties
shown as Fixed no places of decimal.

The data in the mail merge is running to umpteen places of decimal. I have
tried adding the switch \### but that is not working.

Can someone help me please

Many thanks

A


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting numbers in mail merge [email protected] Microsoft Word Help 1 December 3rd 07 03:13 PM
Mail Merge with numbers Chris B. Mailmerge 2 December 19th 06 10:12 PM
MERGE NUMBERS WITH COMA FORMATTING hotty Mailmerge 1 December 30th 05 01:41 PM
formatting numbers mail merged into Word table from an Excel Works Jeannie McQuaid Tables 1 July 27th 05 10:06 PM
How do I fix Mail Merge numbers Laura Mailmerge 2 June 23rd 05 06:17 AM


All times are GMT +1. The time now is 10:49 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"