Word Dispay format

[Guest]

I am facing the following problem ,i want to copy all the contents from an
excel file to word using VB macros , if the number is 32.50
in excel file it'll display in word as 32.5 if the number is 12.11,12.01
it'll display correctly as 12.11,12.02 respectively.The same code works
fine when we are using office 2000 ,only in office 2003 will be the problem
..Could you please tell me the solution ? is there any
default formating in word 2003 which makes to display the docs as 32.5
instead of 32.50 or how can we resolve the issue .

Thanks in advance

 

[Graham Mayor]

I guess this is some sort of mail merge? You need a formatting switch on the
field - something like
{ Mergefield fieldname \# ",#.00" }
should fix it. - http://www.gmayor.com/formatting_word_fields.htm

See also the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

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

My web site www.gmayor.com

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