Excel percentage field as merge field

[Diddy]

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

 

[Diddy]

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

 

[Doug Robbins - Word MVP]

{ = {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]

Thank you Doug
--
Deirdre

{ = {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