Excell Data not displaying properly

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 16 May 2007 00:36 GMT

I have been trying to do a mailmerge where I can take student's grades from a
Excel Spreadsheet and show them in a report done in Word. I use Excel to do
my calculation and it diplays with the % sign that I need. When I do the
merge it shows a decimal point and a large string of numbers. I have tried
the Alt f9 and typing sent before but it just doesn't work.
Any help is appreciated.

Reply to this Message

Doug Robbins - Word MVP - 16 May 2007 04:33 GMT

I assume that the Alt F9 that you refer to is adding a numeric formatting
switch (\# " ") to the field. Exactly what was the modified field
construction and what result does it give?

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 have been trying to do a mailmerge where I can take student's grades from
>a
[quoted text clipped - 5 lines]
> the Alt f9 and typing sent before but it just doesn't work.
> Any help is appreciated.

Reply to this Message

Graham Mayor - 16 May 2007 06:13 GMT

See the section on percentages at
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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have been trying to do a mailmerge where I can take student's
> grades from a Excel Spreadsheet and show them in a report done in
[quoted text clipped - 3 lines]
> before but it just doesn't work.
> Any help is appreciated.

Reply to this Message