Thread: Mail merge
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Billy Liddel Billy Liddel is offline
external usenet poster
 
Posts: 527
Default Mail merge

That's binary arithmetic for you. If column E is a formula use the ROUND
Fuction Say =ROUND(AVERAGE(B3:B6),3)

If the data is imported use a helper column and Round the value in say, E2.
=ROUND(E2,3) and use this column in the Merge. Alternatively, I seem to
remember that you can format a Word Merge field but I can't remember how it
is done. You should get an answer in the Word forums.

HTH
Peter

"Nenagh" wrote:

Hi ,

I am doing a mail merge, on e for the fields is a weight which displays as
.425. When i do the merge this field displays as .4251111333300000 or
similar.

Cheers
--
Nenagh