Thank you Doug :-)
--
Deirdre
"Doug Robbins - Word MVP" wrote:
[Quoted Text] > { = {mergefield fieldname} * 100 \# "0.0%"} > > -- > Hope this helps. > > Please reply to the newsgroup unless you wish to avail yourself of my > services on a paid consulting basis. > > Doug Robbins - Word MVP > > "Diddy" <Diddy[ at ]discussions.microsoft.com> wrote in message > news:8FF99BE1-EF85-4313-80BA-A61725A84847[ at ]microsoft.com... > > Well I've found a partial answer at > > http://www.gmayor.com/formatting_word_fields.htm#basic_switch> > > > {={mergefield}*100\#"0%"} > > > > but this gives it 0 dec places and I'd like 1 dec place. I've tried making > > the 0% 0.0% but no difference. > > > > Any ideas would be brilliant > > -- > > Deirdre > > > > > > "Diddy" wrote: > > > >> Hi everyone, > >> > >> I'm trying to merge data from Excel 2003 into Word 2003 but I'm having > >> trouble with a calculated percentage field which gives 16 dec places when > >> I > >> only need 1. I've tried changing to text but it's still remembering the > >> whole > >> of the number. I've even tried changing to precision as displayed and > >> then > >> doing a copy paste values but this does not make any difference. > >> > >> Any suggestions > >> -- > >> Deirdre > > > |