I just read Mike's reply and I would second it. I would also ad=
d
that it is possible to format the numbers in the mail merge document =
so
that you don't have silly things like 9.800000000000000001. Formatti=
ng
the cell in Excel will not carry over to the Word documents. I use
this procedure for doing progress reports for my students. I mail-me=
rge
my Excel grade book to a progress report. Since the grades are the
results of calculations, I get silly numbers a lot unless I format th=
em.
=20
Click on the merge field. Then use <SHIFT><F9> to reveal the me=
rge
codes. You should see something like {MERGEFIELD
"ClassParticipation01"}. Click between the final quote and the brace=
.
Enter \# and ##.# to format the number to have one decimal place and =
two
leading places. It should look like {MERGEFIELD "ClassParticipation01=
"
\# ##.#} The \# is the numerical formatting switch and the ##.# appl=
ies
the template for the formatting. Using ##.0 instead of a ##.# should
give 12.0 instead of 12. Add # or 0 signs as necessary.
=20
THO
=20
Thomas O'Neill
Physics
Shenandoah Valley Governor's School
=20
-----Original Message-----
=46rom: Dwight K. Souder [mailto:crvhs_dks@CRESTVIEW-RICHLAND.K12.OH.=
US]=20
Sent: Wednesday, June 01, 2005 4:13 PM
To: PHYS-L@LISTS.NAU.EDU
Subject: Quizzes & Spreadsheets
=20
Greetings everyone. I hope the end of the school year is treating yo=
u
well.
I have a question that I'm hoping someone can assist me. In an effor=
t
to
minimize cheating/copying off of one another, I've been giving
assignments
that differ from some of their other classmates. The problem has bee=
n
taking the time to write each one up and the answers.
=20
Recently, I found a way to link Excel to Word. I'm able to make
numerical
changes in Excel, have it automatically do the calculations and put t=
he
numbers and answers in Word document/template. The problem I've
discovered
was that depending on the size of the cell in Excel, the cell also sh=
ows
up
in Word so that the spacing around the values makes it difficult to
read.
=20
What I'm doing is similar to what is done with Access (like creating =
an
address book) and then importing it into a Word document (mail merge =
or
merging it into a form letter). Access is able to input the words an=
d
numbers, without messing up the space around the imported values.
=20
I'm wondering if I have to take a longer route to do what I want to d=
o.
Put
the values in Excel and have it do the calculations. Have the
information
transferred to Access. Then from Access have it merged into Word.
=20
If I do have to take the long route, does anyone know how to do it? =
Is
there a way I can go directly from Excel to Word without messing up t=
he