Reply
 
Thread Tools Display Modes
  #1   Report Post  
 
Posts: n/a
Default Word 2003 mail merge conditional numeric formatting

I did not have this mail merge problem before with old M$ Office 97 but
using the same Word template don't work well with Word 2003. My source
data column in Excel 2003 contains some information currently displayed
and formatted as 'General' mostly with one decimal place and few whole
numbers (without decimals) like below.

NUM
47
52.8
75.6
38
24.1
27.8

In the old Word 97 it will output as is but Word 2003 { MERGEFIELD
''NUM'' } will output

47
52.799999999999997
75.599999999999994
38
24.100000000000001
27.800000000000001

If I try { MERGEFIELD ''NUM'' \# ''0.0''} then
47.0
52.7
75.5
38.0
24.1
27.8

How can I output as whole number if decimal reminder is zero?

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
How do I mail merge to EMAIL from MS Word AND add a pdf attachment Lily@Insight Mailmerge 24 January 15th 07 10:33 PM
word 2003 mail merge filter problems sian Mailmerge 5 August 24th 05 05:33 PM
mail merge hyperlinks in Word 2003 M Mailmerge 1 April 13th 05 11:35 AM
mail merge hyperlinks in Word 2003 M Mailmerge 0 April 12th 05 10:16 PM
Web-Site-based Word Mail Merge & Access DB Alex Maghen Mailmerge 3 January 17th 05 10:52 PM


All times are GMT +1. The time now is 02:24 PM.

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"