[macropod[_2_]]

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