If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|