Doug -- I get a "Syntax Error" when I use the following switch: { = {
MERGEFIELD CAM_PERCENT } * 100 \# 0.00% }

I also tried connecting using the DDE stuff, but I lost all my fields during
the merge, and there are a lot of fields to lose. I think at this point I'd
rather try to get the percent stuff to work. I just don't understand why it
works fine for currency fields, but the percent fields it does not.

....any ideas why?

--
Rone


"Doug Robbins - Word MVP" wrote:

For the following values of CAM_PERCENT, the following field construction
will give the results indicated

{ = { MERGEFIELD CAM_PERCENT } * 100 \# 0.00% }

0.0388 3.88%
3.88 388.00%

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Rone" wrote in message
...
I'm having difficulty getting a percentage field from and Excel sheet to
properly format when I merge it with Word. I've had no problems getting
currency fields to format, but for some reason I can't get the percentages
to
format right.

Here is the switch code I'm using: {MERGEFIELD "CAM_PERCENT" * 100
\#"##.##%"} This displays .0388% But I want it to display 3.88%. I've
also tried using 0's and moving the decimal around, but it hasn't helped
me
any. I saw somewhere where someone used \#"0%", but this only displays
'0%'
when merged.

I'm a bit new to this switching stuff. Does my version of Word have
anything to do with this? Its Word 2003 Professional v. 11.5604

Thanks for the help
--
Rone