DECIMAL POINTS & MERGING

T

Telita

When I merge my Excel spreadsheet into a Word document
all the amounts come out as shown in the formula bar in
Excel and not as shown in the actual cell in the sheet,
e.g. in the formula bar there are no decimal points -
2.000111111 and in the cell it shows up as follows 2.0

Many thanks
T
 
M

macropod

Hi Telita,

You'll probably find that the Excel data is actually the same as what Word's
showing, except that Excel is formatted to show only 2 decimal places.

To get the same result in Word, add a numeric picture switch to the
mailmerge field, like '\# 0.00', so that your field looks something like:

{MEGEFIELD Data \# 0.00} or {MEGEFIELD Data \# 0.00 \* Mergeformat}

Cheers
 
T

Telita

Just to say a BIG THANK YOU to you both. It worked
brilliantly and I have saved it never to forget it!!

T
 
Top