Formatting numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cat - 23 Jun 2006 20:26 GMT

Mailmerge form is created with each field in a text box. The data source is
excel. When merging numbers the comma is lost. I have tried {«land_av»
\###,###}, but it doesn't work. Thanks for your help --
cat

Reply to this Message

Doug Robbins - Word MVP - 23 Jun 2006 21:06 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

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

> Mailmerge form is created with each field in a text box. The data source
> is
> excel. When merging numbers the comma is lost. I have tried {«land_av»
> \###,###}, but it doesn't work. Thanks for your help --
> cat

Reply to this Message

cat - 24 Jun 2006 01:43 GMT

I can format numbers to include the comma in a regular merge document, but I
can't make it work in a text box or a table. Any other suggestions?

Signature

cat

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 6 lines]
> > \###,###}, but it doesn't work. Thanks for your help --
> > cat

Reply to this Message

Doug Robbins - Word MVP - 24 Jun 2006 06:22 GMT

It works in both textboxes and tables for me.

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

>I can format numbers to include the comma in a regular merge document, but
>I
[quoted text clipped - 12 lines]
>> > \###,###}, but it doesn't work. Thanks for your help --
>> > cat

Reply to this Message

Graham Mayor - 25 Jun 2006 06:21 GMT

In what context will it not work? A field is a field and can be formatted
with a switch - however the syntax you quoted earlier is wrong. With
«land_av» displayed press ALT+F9 you will get {Mergefield land_av} Add the
switch inside the brackets eg {Mergefield land_av \# ",0"} will add the
commas. Press F9 to update and ALT+f9 to toggle the display again.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I can format numbers to include the comma in a regular merge
> document, but I can't make it work in a text box or a table. Any
[quoted text clipped - 17 lines]
>>> excel. When merging numbers the comma is lost. I have tried
>>> {«land_av» \###,###}, but it doesn't work. Thanks for your help

Reply to this Message