Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Wilma Wilma is offline
external usenet poster
 
Posts: 5
Default mail merge on word, amounts are reflected with 11 digits not 2


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default mail merge on word, amounts are reflected with 11 digits not 2

Hi Wilma,

To fix this:
.. select the errant merge field
.. press Shift-F9 to expose the field code, which will look something like {MERGEFIELD Data}
.. add a numeric picture switch to the mergefield, thus:
{MERGEFIELD Data \# 0.00} for a plain number with two decimal places
or
{MERGEFIELD Data \# ,0.00} for a number with a thousands separator and two decimal places
or
{MERGEFIELD Data \# $0.00} for a dollars and cents
or
{MERGEFIELD Data \# $,0.00} for a dollars and cents with a thousands separator
.. press F9 to update the field
.. run your mailmerge

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Wilma" wrote in message ...

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
TLB TLB is offline
external usenet poster
 
Posts: 2
Default mail merge on word, amounts are reflected with 11 digits not 2

Do you know any thing about the database server?

"macropod" wrote:

Hi Wilma,

To fix this:
.. select the errant merge field
.. press Shift-F9 to expose the field code, which will look something like {MERGEFIELD Data}
.. add a numeric picture switch to the mergefield, thus:
{MERGEFIELD Data \# 0.00} for a plain number with two decimal places
or
{MERGEFIELD Data \# ,0.00} for a number with a thousands separator and two decimal places
or
{MERGEFIELD Data \# $0.00} for a dollars and cents
or
{MERGEFIELD Data \# $,0.00} for a dollars and cents with a thousands separator
.. press F9 to update the field
.. run your mailmerge

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Wilma" wrote in message ...


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mail merge on word, amounts are reflected with 11 digits not 2

What do you want to know?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"TLB" wrote in message
...
Do you know any thing about the database server?

"macropod" wrote:

Hi Wilma,

To fix this:
.. select the errant merge field
.. press Shift-F9 to expose the field code, which will look something
like {MERGEFIELD Data}
.. add a numeric picture switch to the mergefield, thus:
{MERGEFIELD Data \# 0.00} for a plain number with two decimal places
or
{MERGEFIELD Data \# ,0.00} for a number with a thousands separator and
two decimal places
or
{MERGEFIELD Data \# $0.00} for a dollars and cents
or
{MERGEFIELD Data \# $,0.00} for a dollars and cents with a thousands
separator
.. press F9 to update the field
.. run your mailmerge

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Wilma" wrote in message
...




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
Mail Merge specific amounts of line items Mike C Mailmerge 1 October 7th 06 07:04 AM
Excel Data Source Changes not reflected in the Mail Merge Dave Baxandall Mailmerge 1 July 12th 06 10:45 PM
mail merge dollar amounts Joan Microsoft Word Help 1 May 18th 06 07:05 PM
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 John Richmond, Watford UK Mailmerge 8 April 26th 06 06:00 AM
When I do a mail merge, the zip code merges as only 4 digits. Firegerry Mailmerge 1 March 5th 05 04:08 AM


All times are GMT +1. The time now is 12:56 AM.

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

About Us

"It's about Microsoft Word"