Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Ahmayzin1 Ahmayzin1 is offline
external usenet poster
 
Posts: 1
Default mail merge w/ excel and conditions

Using word format for report; using excel ss for data. Have several
divisions which are not standard. Merge of data to semi-standard is not
problem....getting the numbers formatted is....want to put conditional format
in word.

If number from merge field is smaller than 1 format as percent (no
decimals), if not format as a whole number with commas

sounds simple...but I have spent four full days playing with ifs and {}
help!!!

thanks
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default mail merge w/ excel and conditions

Can you clarify what you mean he

smaller than 1 format as percent (no decimals)


?

e.g.
a. can the number be negative? What then?
b. If the number is .675 do you want 67% or 68% (i.e. standard rounding)
c. if the number is (say) 1000.77 do you want rounding (1,001) or the
integer part only (1,000)?

Taking a few guesses, something along the following lines should do the
trick, where all the {} are the special field braces you can insert
using ctrl-F9:

{ IF { ={ MERGEFIELD mynumber }-1 } = 0 "{ =int({ MERGEFIELD mynumber
}) \#,0 }" "{ { MERGEFIELD }*100 \#0% }" }


Peter Jamieson

http://tips.pjmsn.me.uk

Ahmayzin1 wrote:
Using word format for report; using excel ss for data. Have several
divisions which are not standard. Merge of data to semi-standard is not
problem....getting the numbers formatted is....want to put conditional format
in word.

If number from merge field is smaller than 1 format as percent (no
decimals), if not format as a whole number with commas

sounds simple...but I have spent four full days playing with ifs and {}
help!!!

thanks

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default mail merge w/ excel and conditions

Hi Ahmayzin1,

Try:
{IF{MERGEFIELD Data} 1 {={MERGEFIELD Data}*100 \# "0%"} {MERGEFIELD Data \# ",0"}}
where 'Data' is your merfield name.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


"Ahmayzin1" wrote in message ...
Using word format for report; using excel ss for data. Have several
divisions which are not standard. Merge of data to semi-standard is not
problem....getting the numbers formatted is....want to put conditional format
in word.

If number from merge field is smaller than 1 format as percent (no
decimals), if not format as a whole number with commas

sounds simple...but I have spent four full days playing with ifs and {}
help!!!

thanks


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
MS Word Mail Merge from Excel -- Force Excel to open the datafile? [email protected] Mailmerge 6 September 26th 08 03:08 PM
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 John Richmond, Watford UK Mailmerge 8 April 26th 06 06:00 AM
mail merge from excel-date in excel January 1, 2005 -merged dbase. Elaine Ballon Mailmerge 1 December 23rd 05 09:31 AM
Multiple conditions in merge Stephen Green Mailmerge 12 December 20th 05 07:38 PM
Filtering does not work from Excel - changed conditions by random Gunder Mailmerge 1 March 22nd 05 10:01 PM


All times are GMT +1. The time now is 01:15 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"