Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
elginone elginone is offline
external usenet poster
 
Posts: 1
Default word mail merge does not format number imported to 2 decimal place

mail merge works, but dollar amount are not rounded to 2 decimal places as
they are in excel the data base


  #2   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 word mail merge does not format number imported to 2 decimal place

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at
http://www.gmayor.com/formatting_word_fields.htm


--
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, originally posted via msnews.microsoft.com

"elginone" wrote in message
...
mail merge works, but dollar amount are not rounded to 2 decimal places as
they are in excel the data base


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
Why Word 2007 mail merge does not retain number format from Excel sretep Mailmerge 1 June 6th 09 02:55 PM
Limit merge to 2 decimal place Francis Mailmerge 3 February 12th 08 07:17 AM
Limit the number of decimal places shown when I merge Excel-Word Bill W Mailmerge 1 January 8th 08 01:28 AM
How do I stop decimal number truncation in mail merge? Bob Emery Mailmerge 1 January 18th 06 08:25 PM
merge field numbering/decimal place problem gremlinsgimi Mailmerge 1 April 9th 05 09:40 AM


All times are GMT +1. The time now is 09:03 AM.

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"