word vs excel student results

[mtenbos]

When i merge word with excel result i get some results with 8 caracters
behind the comma.

i have this comand set up: {MERGEFIELD"M_38_ZH"0,0}
In other fields the results is good but some fields the result comes as
for excample 5,7000000000000002
it should be 5,7

in excel the settings are good with 1 decimal etc etc..
I dont know it anymore HELP!!!

 

[Graham Mayor]

You need a formatting switch eg
{MERGEFIELD"M_38_ZH" \# "#,0"}
See http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Anne Troy]

Try this:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com