[Yr7-10it] weird excel

[DUNLOP, James]

Dear Andrew

 

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.

 

James DUNLOP

KLA Manager

Western Heights College.

 

________________________________

From: yr7-10it-bounces at edulists.com.au
[mailto:yr7-10it-bounces at edulists.com.au] On Behalf Of Andrew Grimshaw
Sent: Friday, 3 June 2005 10:37
To: Year 7 - 10 Information Technology Teachers' Mailing List
Subject: [Yr7-10it] weird excel

 

HI 

 

ive got a weird bug on an excel/word merge

 

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)

 

lol, andrew grimshaw

Important - 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._______________________________________________ 
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
Year 7 - 10 IT Mailing List kindly supported by 
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
Authority and 
http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/yr7-10it/attachments/20050603/f5341557/attachment.html