Displaying Two Decimal Places in Merged Excel Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Debs - 20 Dec 2007 14:27 GMT

Hi

I would like to merge numerical data from Excel which has been formatted as
£1,000.10 in a Word doc. When I do this however in the Word doc it does not
display .10 but .1 even though it has been formatted in Excel to show two
characters after the decimal Point?

Any help most appreciated!

Debs

Reply to this Message

Graham Mayor - 20 Dec 2007 14:53 GMT

The formatting in Excel is irrelevant. Add a formatting switch to the Word
field

{Mergefield Fieldname \# "£,0.00" }

see 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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi
>
[quoted text clipped - 6 lines]
>
> Debs

Reply to this Message

Debs - 20 Dec 2007 15:35 GMT

Many thanks for you help Graham it works perfectly!

Debs

> The formatting in Excel is irrelevant. Add a formatting switch to the Word
> field
[quoted text clipped - 13 lines]
> >
> > Debs

Reply to this Message

Graham Mayor - 20 Dec 2007 15:48 GMT

You are welcome :)

Signature

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

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

> Many thanks for you help Graham it works perfectly!
>
[quoted text clipped - 25 lines]
>>>
>>> Debs

Reply to this Message