Format Excel cell in Word Mailmerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Geert - 14 Feb 2008 08:54 GMT

Hi,
I try to merge formatted Excel cells (€ #.##0,00) into a Word document.
Word displays a number with to many decimals (for example: 4600,2546897458)

How can I copy the format?

Thanks,

Signature

Geert

Reply to this Message

Geert - 14 Feb 2008 09:05 GMT

I'm working with Excel and Word 2003,..

Signature

Geert

> Hi,
> I try to merge formatted Excel cells (€ #.##0,00) into a Word document.
[quoted text clipped - 3 lines]
>
> Thanks,

Reply to this Message

Doug Robbins - Word MVP - 14 Feb 2008 09:16 GMT

Press Alt+F9 to toggle on the display of the field codes and inside the
closing } of the field to which you want to apply the format, add the
following formatting switch:

\# "?,0.00"

If you have negative amounts and you want to enclose them in parentheses,
use

\# "?,0.00;(?,0.00)"

Signature

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

> Hi,
> I try to merge formatted Excel cells (? #.##0,00) into a Word document.
[quoted text clipped - 4 lines]
>
> Thanks,

Reply to this Message

Peter Jamieson - 14 Feb 2008 09:19 GMT

Use Alt-F9 to reveal the field codes in your Word mail merge main document
and

change e.g.

{ MERGEFIELD mynumber }

to

{ MERGEFIELD mynumber \#"€ #.##0,00" }

(you can usually delete the \*Mergeformat switch if it is there)

I'm assuming "." is set up as the 1000s separator and the "," as the decimal
point in your regional options.

You may find the following is enough:

{ MERGEFIELD mynumber \#"€.0,00" }

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Hi,
> I try to merge formatted Excel cells (€ #.##0,00) into a Word document.
[quoted text clipped - 4 lines]
>
> Thanks,

Reply to this Message