When I merge excel with word I lose the currency digit ex ..

Johnnylaw · External Since: Sep 24, 2009 Posts: 2

I set the currency and the decimal to 2 but when I merge into word I get a
loss of the last digit if it is zero

Peter Jamieson · External Since: Jan 15, 2009 Posts: 94

Use Alt-F9 to display your field codes.

Find the one you need to change. It will probably look like
{ MERGEFIELD mynumber }
or
{ MERGEFIELD mynumber \*Mergeformat }

Remove any \*Mergeformat and type
\#0.00

so that you have

{ MERGEFIELD mynumber \#0.00 }

Use Alt-F9 to display field results.

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Johnnylaw wrote:
> I set the currency and the decimal to 2 but when I merge into word I get a
> loss of the last digit if it is zero

Peter Jamieson · External Since: Jan 15, 2009 Posts: 94

Sorry, ignore the other message.

Use Alt-F9 to display your field codes.

Find the one you need to change. It will probably look like
{ MERGEFIELD mynumber }
or
{ MERGEFIELD mynumber \*Mergeformat }

Remove any \*Mergeformat and type
\#$0.00

so that you have

{ MERGEFIELD mynumber \#$0.00 }

Or if your outputt needs to have thousands separators, use

{ MERGEFIELD mynumber \#$,0.00 }

Use Alt-F9 to display field results.
Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Johnnylaw wrote:
> I set the currency and the decimal to 2 but when I merge into word I get a
> loss of the last digit if it is zero

Johnnylaw · External Since: Sep 24, 2009 Posts: 2

Thanks!!! I figured it out with your help!!

"Peter Jamieson" wrote:

> Sorry, ignore the other message.
>
> Use Alt-F9 to display your field codes.
>
> Find the one you need to change. It will probably look like
> { MERGEFIELD mynumber }
> or
> { MERGEFIELD mynumber \*Mergeformat }
>
> Remove any \*Mergeformat and type
> \#$0.00
>
> so that you have
>
> { MERGEFIELD mynumber \#$0.00 }
>
> Or if your outputt needs to have thousands separators, use
>
> { MERGEFIELD mynumber \#$,0.00 }
>
> Use Alt-F9 to display field results.
> Peter Jamieson
>
> http://tips.pjmsn.me.uk
> Visit Londinium at http://www.ralphwatson.tv
>
> Johnnylaw wrote:
> > I set the currency and the decimal to 2 but when I merge into word I get a
> > loss of the last digit if it is zero
>