<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2627" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType name="PlaceType"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="PlaceName"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>
st1\:*{behavior:url(#default#ieooui) }
</STYLE>
<![endif]-->
<STYLE>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
p.MsoHeader, li.MsoHeader, div.MsoHeader
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
p.MsoFooter, li.MsoFooter, div.MsoFooter
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
/* Page Definitions */
@page
{mso-endnote-separator:url("cid:header.htm\@01C5682B.7522BB20") es;
mso-endnote-continuation-separator:url("cid:header.htm\@01C5682B.7522BB20") ecs;}
@page Section1
{size:595.3pt 841.9pt;
margin:2.0cm 2.0cm 2.0cm 2.0cm;
mso-footer:url("cid:header.htm\@01C5682B.7522BB20") f1;}
div.Section1
{page:Section1;}
-->
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-AU vLink=blue link=blue bgColor=white>
<DIV><FONT face=Arial size=2>thx for advice but i still cant get it to
work</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>tried changin the format in excel but no
luck</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>i cant even find where to change the field format
in word - riight clicking no good!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>-andrew grimshaw</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=DUNLJ@whc.vic.edu.au href="mailto:DUNLJ@whc.vic.edu.au">DUNLOP,
James</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=yr7-10it@edulists.com.au
href="mailto:yr7-10it@edulists.com.au">Year 7 - 10 Information Technology
Teachers' Mailing List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, June 03, 2005 11:00
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Yr7-10it] weird excel</DIV>
<DIV><BR></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Dear
Andrew<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">In Word, the field
where the mailmerge data is placed can be formatted to 1 decimal place (or
whatever). It happens to me all the time when I create individual
Mathematics assignments by mailmerging Excel data into a Word master
document.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">James
DUNLOP<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">KLA
Manager<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><st1:place w:st="on"><st1:PlaceName w:st="on"><FONT
face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Western</SPAN></FONT></st1:PlaceName><FONT
face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> <st1:PlaceType
w:st="on">Heights</st1:PlaceType> <st1:PlaceType
w:st="on">College</st1:PlaceType></SPAN></FONT></st1:place><FONT face=Arial
color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN lang=EN-US
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <A
href="mailto:yr7-10it-bounces@edulists.com.au">yr7-10it-bounces@edulists.com.au</A>
[mailto:yr7-10it-bounces@edulists.com.au] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Andrew Grimshaw<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Friday, 3 June 2005
10:37<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Year 7 - 10
Information Technology Teachers' Mailing List<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> [Yr7-10it] weird
excel</SPAN></FONT><SPAN lang=EN-US><o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">HI
</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">ive got a weird bug on an
excel/word merge</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">i have to put the group number (ie
12.2) on hte report, but when i merge i get a message that there is a
"field error" and it then prints 12.1999999999999999999 (or
12.30000000000000001 instead of 12.3)</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">lol, andrew
grimshaw</SPAN></FONT><o:p></o:p></P></DIV>
<P><B><FONT face="Times New Roman" size=3><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">Important - </SPAN></FONT></B>This
email and any attachments may be confidential. If received in error, please
contact us and delete all copies. Before opening or using attachments check
them for viruses and defects. Regardless of any loss, damage or consequence,
whether caused by the negligence of the sender or not, resulting directly or
indirectly from the use of any attached files our liability is limited to
resupplying any affected attachments. Any representations or opinions
expressed are those of the individual sender, and not necessarily those of the
Department of Education &
Training._______________________________________________ <BR><A
href="http://www.edulists.com.au">http://www.edulists.com.au </A>- FAQ,
resources, subscribe, unsubscribe <BR>Year 7 - 10 IT Mailing List kindly
supported by <BR><A
href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au </A>- Victorian
Curriculum and Assessment Authority and <BR><A
href="http://www.vitta.org.au">http://www.vitta.org.au </A>- VITTA Victorian
Information Technology Teachers Association
Inc<o:p></o:p></P></DIV>_______________________________________________ <BR><A
href="http://www.edulists.com.au">http://www.edulists.com.au </A>- FAQ,
resources, subscribe, unsubscribe <BR>Year 7 - 10 IT Mailing List kindly
supported by <BR><A
href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au </A>- Victorian
Curriculum and Assessment Authority and <BR><A
href="http://www.vitta.org.au">http://www.vitta.org.au </A>- VITTA Victorian
Information Technology Teachers Association Inc </BLOCKQUOTE><p></p><p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.</BODY></HTML>