View Single Post
  #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