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