How do i format how a number field displays?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maui Time Jen - 13 Sep 2005 22:57 GMT

In my excel doc that is the merge source i have a series of data that is a
number like 9.27, 9.28, 9.29. They are not formulas. When i merge the data it
comes in as 9.27000000000, 9.2800000000000, etc. How do i get these numbers
to appear in the merge doc as just a two decimal number? I am trying to use
the switches with no success. When i add a numchar switch i get a series of
random numbers like 38, 39, 110. That has nothing to do wiht the merged data.

Reply to this Message

Anne Troy - 13 Sep 2005 23:03 GMT

Try this, Jen:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
************
Anne Troy
www.OfficeArticles.com

> In my excel doc that is the merge source i have a series of data that is a
> number like 9.27, 9.28, 9.29. They are not formulas. When i merge the data
[quoted text clipped - 7 lines]
> random numbers like 38, 39, 110. That has nothing to do wiht the merged
> data.

Reply to this Message

Graham Mayor - 14 Sep 2005 04:55 GMT

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

Signature

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

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

> In my excel doc that is the merge source i have a series of data that
> is a number like 9.27, 9.28, 9.29. They are not formulas. When i
[quoted text clipped - 3 lines]
> i add a numchar switch i get a series of random numbers like 38, 39,
> 110. That has nothing to do wiht the merged data.

Reply to this Message