View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Andy Roberts Andy Roberts is offline
external usenet poster
 
Posts: 24
Default Round number down in mail merge

I have a number being merged from excel which is formatted to 1 decimal
place in excel (e.g. 1.6). When it comes through to word as part of the
mail merge it displays as a true number (1.666666666666667) and I want it to
display to 1dp. I'm aware of switches to control formatting but don't know
how to do this with number formats / decimal places within the word doc.

Can anyone shed light on it?

--
Regards

Andy

Andy Roberts
Win XP, Office 2007